Passwords and batch processes (was Re: Problem with Dump)

On Fri, 23 Aug 2002, Ian Barwick wrote:

> AFAIK utilities such as pg_dump prompt for the password but
> won't accept it as a command line option, which makes password-based
> authentication almost unusable when calling these utilities from a script.

This really should be Question #1 in the FAQ.

You can set the environment variable PGPASSWORD to the password, and avoid
prompts.  This assumes the same username/password has access to all the
databases for pg_dumpall.

I didn't find this documented anywhere.  It probably is, but somewhere
buried...

--
David.