Skip site navigation (1) Skip section navigation (2)

Re: BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

From: "mark" <dvlhntr(at)gmail(dot)com>
To: "'Robert Haas'" <robertmhaas(at)gmail(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.
Date: 2011-01-30 19:45:20
Message-ID: 041001cbc0b6$3b4f3a60$b1edaf20$@com (view raw or flat)
Thread:
Lists: pgsql-bugs

> -----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
> 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'
> 
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)

-Mark


> 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

Responses

pgsql-bugs by date

Next:From: Robert HaasDate: 2011-01-31 01:30:46
Subject: Re: BUG #5844: maverick
Previous:From: Robert HaasDate: 2011-01-30 19:19:11
Subject: Re: BUG #5851: ROHS (read only hot standby) needs to be restarted manually in somecases.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group