Re: ~/pgpass

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: ~/pgpass
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C78B3@algol.sollentuna.se
обсуждение исходный текст
Ответ на ~/pgpass  (Oluwatope Akinniyi <tope.akinniyi@shepherdhill.biz>)
Список pgsql-general
> > On Fedora: wrong file permissions?
> > Btw.: ~/.pgpass is only supported in 7.3 and later.
>
> Thanks.
>
> The permission is 0600 on Fedora. But must the file
> (~/.pgpass) be owned by postgres? Also what could explain the
> reason why it is not working on Windows XP where permission
> is not checked!
>
> I am running version 8.0.3 that is shipped with Fedora Core 4.
>
> The content of both ~/.pgpass and pgpass.conf is:
>
> 192.168.0.253:5432:hms:xxxxxx

That's not the correct format. See
http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html:

hostname:port:database:username:password

You are either missing database or userid, depending on what "hms" is.

//Magnus

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: 5 new entries for FAQ
Следующее
От: Mage
Дата:
Сообщение: Re: atomic function