From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
Cc: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: SR: "pseudo replication database of the primary" ... |
Date: | 2010-02-19 03:47:16 |
Message-ID: | 201002190347.o1J3lGR11485@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Fujii Masao wrote:
> On Fri, Feb 19, 2010 at 12:25 AM, Marc G. Fournier <scrappy(at)hub(dot)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 <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2010-02-19 03:51:13 | Re: SR: "pseudo replication database of the primary" ... |
Previous Message | Fujii Masao | 2010-02-19 03:44:50 | Re: SR: "pseudo replication database of the primary" ... |