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.