On Wed, Jan 26, 2011 at 09:18:01PM -0500, Bruce Momjian wrote: > > 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.
Yep. Simon shows it the other way in his book: "If you want a Standby to notice that the connection to the Master has dropped, you need to set the keepalives in the primary_conninfo in the recovery.conf" That works, also. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
