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/
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
