Re: Understanding PG9.0 streaming replication feature

Ray Stell wrote:
> On Wed, Jan 26, 2011 at 02:22:41PM -0800, Dan Birken wrote:
> > > Can you give some concrete suggestions on what needs to be added? The
> > > current documentation is here:
> > >
> > > http://developer.postgresql.org/pgdocs/postgres/index.html
>
>
> I had some difficulty getting the keepalives syntax in recovery.conf.
>
> http://developer.postgresql.org/pgdocs/postgres/warm-standby.html#STREAMING-REPLICATION
>
> might stand an example. When you click on the link there it takes you here:
>
> http://developer.postgresql.org/pgdocs/postgres/runtime-config-connection.html#GUC-TCP-KEEPALIVES-IDLE
>
> which doesn't help to much. Somewhere I found a comment that did it this way:
>
> primary_conninfo = 'host=test user=fred keepalives_idle= 60 '
>
> The example I found for this in "PostgreSQL 9 Admin Cookbook" didn't
> fly: primary_conninfo = '....options="-c tcp_keepalives_idle= 60" ...'
> I didn't check the erratta. Just sayin....

Uh, the sentence is:

On systems that support the keepalive socket option, setting
tcp_keepalives_idle, tcp_keepalives_interval and tcp_keepalives_count
helps the primary promptly notice a broken connection.

I believe there they are talking about setting those values in the
master/primary so you see the slave has disconnected --- this is not
related to setting in the connection string, I think.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +