Re: PGPASSWORD

Поиск
Список
Период
Сортировка
От Milen A. Radev
Тема Re: PGPASSWORD
Дата
Msg-id 43FE1E5C.7010604@radev.net
обсуждение исходный текст
Ответ на PGPASSWORD  ("Mr. Dan" <bitsandbytes88@hotmail.com>)
Ответы Re: PGPASSWORD  ("Mr. Dan" <bitsandbytes88@hotmail.com>)
Список pgsql-admin
Mr. Dan написа:
> Hi,
>
> When I was running 8.0.X on linux, I didn't have to include the postgres
> -P password in my shell scripts(.sh).  After I switched to 8.1.X, I've
> had to include the -P PASSWORD ****** in all my scripts.  I'm thinking
> I'll just add PGPASSWORD as a postgres environment variable instead.   I
> did start running 8.1.X on a port that is different from the default, so
> I added PGPORT as an environment variable, so I don't have to include -p
> PORT NUMBER.  Has anyone else noticed they had to start including a
> password for the postgres user in 8.1.X?  Is there any concern to adding
> PGPASSWORD as an environment variable.
>

See the paragraph about "PGPASSWORD" at
http://www.postgresql.org/docs/8.1/static/libpq-envars.html - it
recommends the use of "~/.pgpass" file.


BTW I can't seem to find any reference to a "-P" parameter related to
supplying a password.


--
Milen A. Radev

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Tomeh, Husam"
Дата:
Сообщение: Re: problems to install PostgreSQL
Следующее
От: "Mr. Dan"
Дата:
Сообщение: Re: PGPASSWORD