Prev: tribble.postgresql.org - planned maintenance downtime
Next: 'replication' keyword on .pgpass (Streaming Replication)
From: Alvaro Herrera on 6 Jan 2010 09:02 Fujii Masao escribi�: > On Sat, Dec 26, 2009 at 10:55 AM, Fujii Masao <masao.fujii(a)gmail.com> wrote: > > On Fri, Dec 25, 2009 at 9:56 PM, Andrew Dunstan <andrew(a)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 -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |