Re: SR: "pseudo replication database of the primary" ...

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 ;)

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center