Re: Automated backup problems - pg_dump - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Automated backup problems - pg_dump
Date
Msg-id 20030825003812.G79187-100000@megazone.bigpanda.com
Whole thread Raw
In response to Automated backup problems - pg_dump  (Jesse Burkhardt <jesse@skybuilders.com>)
Responses Re: Automated backup problems - pg_dump  (Jesse Burkhardt <jesse@skybuilders.com>)
Re: Automated backup problems - pg_dump  (Chris Miles <chris_pg002@psychofx.com>)
List pgsql-admin
On Sun, 24 Aug 2003, Jesse Burkhardt wrote:

> I am sure many of you have encountered the problems I am experiencing
> with automating the pg_dump command from a cron. The problem arises from
> a failure of this command to use the environmental variable,
> PG_PASSWORD. (PGUSER, on the other hand, is picked up during command

I think the environment variable is PGPASSWORD (no underscore) in at least
7.3 and above.  Also, it's somewhat depricated in favor of using the
.pgpass file.


pgsql-admin by date:

Previous
From: Jesse Burkhardt
Date:
Subject: Automated backup problems - pg_dump
Next
From: "Jaskier"
Date:
Subject: System Tables