Re: Understanding PG9.0 streaming replication feature

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: Dan Birken <dan(at)thumbtack(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Ben Carbery <ben(dot)carbery(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Understanding PG9.0 streaming replication feature
Date: 2011-01-27 02:02:24
Message-ID: 20110127020224.GB31642@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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....

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2011-01-27 02:18:01 Re: Understanding PG9.0 streaming replication feature
Previous Message Bruce Momjian 2011-01-27 00:55:13 Re: Understanding PG9.0 streaming replication feature