> -----Original Message-----
> From: Robert Haas [mailto:robertmhaas(at)gmail(dot)com]
> Sent: Sunday, January 30, 2011 12:19 PM
> To: mark
> Cc: pgsql-bugs(at)postgresql(dot)org
> Subject: Re: [BUGS] BUG #5851: ROHS (read only hot standby) needs to be
> restarted manually in somecases.
> On Fri, Jan 28, 2011 at 1:03 PM, mark <dvlhntr(at)gmail(dot)com> wrote:
> > When showing the setting on the slave or master all tcp_keepalive
> > (idle, interval and count) are showing 0;
> > The config file shows interval and count commented out, but idle in
> > 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'
Thanks I will try this on Monday and will report back if it fixes the
problem. (however since I can't reproduce the issue on demand it might be a
waiting game. Might not know for a month or so tho)
> 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
In response to
pgsql-bugs by date
|Next:||From: Robert Haas||Date: 2011-01-31 01:30:46|
|Subject: Re: BUG #5844: maverick|
|Previous:||From: Robert Haas||Date: 2011-01-30 19:19:11|
|Subject: Re: BUG #5851: ROHS (read only hot standby) needs to be
restarted manually in somecases.|