Yes the variable is actually: PGPASSWORD
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 p
At 03:46 PM 8/24/2003 , Jesse Burkhardt wrote:
One (non-trivial) solution is to use a cron (like fcron) that allows you to
set the environment of the executed process.
I like fcron very much, but you'd have to be the system administer (or his
cooperation) to install it.
>I am sure many of you
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, i
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
execution.) The cron s
