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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org