Re: Automated backup problems - pg_dump - Mailing list pgsql-admin

From Jesse Burkhardt
Subject Re: Automated backup problems - pg_dump
Date
Msg-id 3F4A5E5D.3050502@skybuilders.com
Whole thread Raw
In response to Re: Automated backup problems - pg_dump  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Archie MacDonald (rsh)"
Date:
Subject: readline-4.2a compile ,installation problem
Next
From: Jonathan Ellis
Date:
Subject: Tuning: WAL disk speed