Re: Automated backup problems - pg_dump

Yes the variable is actually: PGPASSWORD

I have a crond pg_dump script (as root) that sets this variable and
dumps with "-U postgres" and uses the variable successfully.
(7.2.4).

Cheers
CM

Stephan Szabo wrote:
> 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.

--
Chris Miles
http://chrismiles.info/