Fujii Masao wrote: > On Fri, Feb 19, 2010 at 12:25 AM, Marc G. Fournier <scra...@hub.org> wrote: > > I'm reading through the Wiki docs, and one thing isn't clear: > > > > "3. Set up connections and authentication so that the standby server can > > successfully connect to the pseudo replication database of the primary." > > > > I've searched Google, to see if its mentioned anywhere else, but nadda ... > > can't connect to it using psql, which makes it confusing as to why I'm > > configuring access to it via pg_hba.conf ... > > Yeah, since there is no 'replication' database unless user explicitly > creates it, psql would be unable to connect to it. 'replication' is the > keyword of pg_hba.conf only for authenticating the standby server. This > keyword needs to be specified in the 'database' field of pg_hba.conf. > So I expressed it as the pseudo replication database. Please see the > document for details. > > http://developer.postgresql.org/pgdocs/postgres/streaming-replication.html#STREAMING-REPLICATION-AUTHENTICATION > http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html > > If that expression is confusing, please feel free to modify it in the > wiki and doc ;)
FYI, I have modified the SGML docs to call it a "replication pseudo-database". -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers