Search Postgresql Archives

Re: Understanding PG9.0 streaming replication feature

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux