Re: How to automate password requests? - Mailing list pgsql-general

From Alan Hodgson
Subject Re: How to automate password requests?
Date
Msg-id 200711281046.43395@hal.medialogik.com
Whole thread Raw
In response to How to automate password requests?  (Marten Lehmann <lehmann@cnm.de>)
List pgsql-general
On Wednesday 28 November 2007, Marten Lehmann <lehmann@cnm.de> wrote:
> Hello,
>
> I'm trying to automate some postgresql scripts, but I cannot find a way
> to pass a password directly to commands like pg_dump psql and so on.
> Even a
>
> echo "password" | psql
>
> doesn't work, the password prompt of psql is still waiting.
>
> mysql has the -p option. What would be the postgresql equivalent? I
> don't want to enter passwords dozend times.
>

create a .pgpass file.

--
The global consumer economy can best be described as the most efficient way
to convert natural resources into waste.


pgsql-general by date:

Previous
From: Tom Hart
Date:
Subject: Re: How to automate password requests?
Next
From: "Gauthier, Dave"
Date:
Subject: Re: Select all fields except one