Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dumpall asking for password for each database - Mailing list pgsql-general

From Scott Mead
Subject Re: pg_dumpall asking for password for each database
Date
Msg-id d3ab2ec80910061411p132248f4t91bdab0bf32852a1@mail.gmail.com
Whole thread Raw
In response to pg_dumpall asking for password for each database  (Krzysztof Barlik <kbarlik@wp.pl>)
List pgsql-general
Tree view


2009/10/6 Krzysztof Barlik <kbarlik@wp.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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Composite types and tables - when to use?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pg_dumpall asking for password for each database