Re: pg_dumpall asking for password for each database

From: Scott Mead <scott(dot)lists(at)enterprisedb(dot)com>
To: Krzysztof Barlik <kbarlik(at)wp(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dumpall asking for password for each database
Date: 2009-10-06 21:11:57
Message-ID: d3ab2ec80910061411p132248f4t91bdab0bf32852a1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-10-06 21:45:58 Re: pg_dumpall asking for password for each database
Previous Message Merlin Moncure 2009-10-06 20:59:54 Re: Composite types and tables - when to use?