Re: Automated backup problems - pg_dump

Yo Stephan,

Thanks. That was the problem: that there is no longer and underscore in the pg password env var, PGPASSWORD.

Are you familiar with the Hungarian jazz guitarist Gabo Szabo?

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. 

-- 
Jesse Burkhardtjesse@skybuilders.com  (w) 617-876-5680goose@aerogoose.com    (h) 617-354-5523