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