Re: Automated backup problems - pg_dump

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 Burkhardt
jesse(at)skybuilders(dot)com (w) 617-876-5680
goose(at)aerogoose(dot)com (h) 617-354-5523