Re: How to automate password requests?

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: How to automate password requests?
Дата
Msg-id 200711281046.43395@hal.medialogik.com
обсуждение исходный текст
Ответ на How to automate password requests?  (Marten Lehmann <lehmann@cnm.de>)
Список 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 по дате отправления:

Предыдущее
От: Tom Hart
Дата:
Сообщение: Re: How to automate password requests?
Следующее
От: "Gauthier, Dave"
Дата:
Сообщение: Re: Select all fields except one