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.