Re: streaming replication breaks horribly if master crashes

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Robert Haas" <robertmhaas@gmail.com>, "Stefan Kaltenbrunner" <stefan@kaltenbrunner.cc>
Cc: "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Date: 2010-06-16T20:14:02Z
Lists: pgsql-hackers
Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> wrote:
 
> well this is likely caused by the OS not noticing that the
> connections went away (linux has really long timeouts here) -
> maybe we should unconditionally enable keepalive on systems that
> support that for replication connections (if that is possible in
> the current design anyway)
 
Yeah, in similar situations I've had good results with a keepalive
timeout of a minute or two.
 
-Kevin