Re: 'replication' keyword on .pgpass (Streaming Replication)

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: 'replication' keyword on .pgpass (Streaming Replication)
Дата
Msg-id 20100106140241.GB6129@alvh.no-ip.org
обсуждение исходный текст
Ответ на 'replication' keyword on .pgpass (Streaming Replication)  (Fujii Masao <masao.fujii@gmail.com>)
Ответы Re: 'replication' keyword on .pgpass (Streaming Replication)  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
Fujii Masao escribió:
> On Sat, Dec 26, 2009 at 10:55 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
> > On Fri, Dec 25, 2009 at 9:56 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
> >> I don't see the use case for it - .pgpass is for single users, not a whole
> >> cluster. And it does support wildcards, which takes care of the 'all' case.
> >> In the case of pg_hba.conf we don't know in advance who will actually be
> >> connecting. But in the case of .pgpass we do, so the extra utility of
> >> 'sameuser', 'samerole' and 'samegroup' in this case is not apparent to me.
> >
> > OK, I might need to focus only on the use of replication, without
> > being avaricious.
> 
> The attached patch supports new keyword 'replication' on .pgpass file.
> This keyword is used to specify the password for the standby server to
> connect to the primary server.

Would it make more sense to have a separate password file for the
replication stuff?  Say .pgreplicationpass or whatever.


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Change Catalog
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: 'replication' keyword on .pgpass (Streaming Replication)