Re: pg_dumpall asking for password for each database

From: "Joshua D(dot) Drake" <jd(at)commandprompt(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:45:58
Message-ID: 1254865558.30674.1610.camel@jd-desktop.unknown.charter.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2009-10-06 at 22:59 +0200, Krzysztof Barlik wrote:
> 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.

take a look at .pgpass documentation

>
> Thanks,
> Krzysztof
>
>
>
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Uckun 2009-10-06 22:14:14 Re: Postgres won't start. Nothing in the log.
Previous Message Scott Mead 2009-10-06 21:11:57 Re: pg_dumpall asking for password for each database