On Fri, Jan 28, 2011 at 1:03 PM, mark <dvlh...@gmail.com> wrote: > When showing the setting on the slave or master all tcp_keepalive settings > (idle, interval and count) are showing 0; > > The config file shows interval and count commented out, but idle in the > config file is set to 2100. > > Possible that "show tcp_keepalive_idle;" isn't reporting accurately ? (or a > value that high isn't be accepted?) > > I have reloaded configs and still seeing 0's > > > > I assume you would suggest I turn that number down... a lot.
Yeah, the defaults are way too long for our purposes. The way to get this set correctly, I think, is to set it in the primary_conninfo stream on the slave. You end up with something like this: primary_conninfo='host=blahblah user=bob keepalives_idle=XX keepalives_interval=XX keepalives_count=XX' I'm of the opinion that we really need an application-level keepalive here, but the above is certainly a lot better than nothing. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs