2009/10/6 Krzysztof Barlik <kbarlik(at)wp(dot)pl>
> 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