Re: pg_dumpall asking for password for each database

[Scott Mead <scott.lists@xxxxxxxxxxxxxxxx>]

2009/10/6 Krzysztof Barlik <kbarlik@xxxxx>

Hi,

 is it possible to force pg_dumpall to ask for
password only once (connecting as superuser 'postgres') ?

Entering it for every database is a bit annoying.

Kind of, you'll either use an environment variable:
     
http://www.postgresql.org/docs/8.4/interactive/libpq-envars.html
    (specifically PGPASSWORD)

   or the pgpass file:

http://www.postgresql.org/docs/´8.4/interactive/libpq-pgpass.html

--Scott