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