From:
Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To:
pgsql-hackers(at)postgresql(dot)org
Cc:
Tollef Fog Heen <tollef(dot)fog(dot)heen(at)collabora(dot)co(dot)uk>, Robert Haas <robertmhaas(at)gmail(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Subject:
Re: TCP keepalive support for libpq
Date:
2010-02-11 16:43:01
Message-ID:
db471ace1002110843o2db8cc90md076b1fd79619d9c@mail.gmail.com (view raw or flat )
Thread:
2010-02-09 13:03:28 from Tollef Fog Heen <tollef(dot)fog(dot)heen(at)collabora(dot)co(dot)uk>
2010-02-09 13:45:01 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-09 13:57:24 from Tollef Fog Heen <tollef(dot)fog(dot)heen(at)collabora(dot)co(dot)uk>
2010-02-09 14:34:10 from Andrew Chernow <ac(at)esilo(dot)com>
2010-02-10 01:07:29 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-02-10 21:08:58 from daveg <daveg(at)sonic(dot)net>
2010-02-11 07:15:36 from Tollef Fog Heen <tollef(dot)fog(dot)heen(at)collabora(dot)co(dot)uk>
2010-02-11 16:16:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-11 16:27:43 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-02-11 16:33:35 from Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
2010-02-11 16:43:01 from Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
2010-02-12 02:52:27 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-02-12 09:40:26 from Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
2010-02-12 10:15:32 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-02-11 16:38:19 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-02-11 16:34:52 from Andrew Chernow <ac(at)esilo(dot)com>
2010-02-11 17:08:03 from Tollef Fog Heen <tollef(dot)fog(dot)heen(at)collabora(dot)co(dot)uk>
2010-02-12 15:50:30 from Marko Kreen <markokr(at)gmail(dot)com>
2010-02-12 17:13:06 from Euler Taveira de Oliveira <euler(at)timbira(dot)com>
2010-02-15 10:18:40 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-02-15 14:45:02 from Euler Taveira de Oliveira <euler(at)timbira(dot)com>
2010-02-15 14:52:13 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-15 15:08:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-15 15:15:24 from Euler Taveira de Oliveira <euler(at)timbira(dot)com>
2010-02-15 16:00:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-15 16:08:23 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-15 16:12:14 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-15 16:15:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-15 16:18:40 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-16 00:58:05 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-22 13:20:39 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-22 13:27:28 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-06-22 16:16:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-22 16:32:08 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-06-22 16:43:00 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-22 16:50:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-22 17:08:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-22 17:14:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-22 17:32:26 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-22 18:02:02 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-06-22 18:20:31 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-06-22 18:24:23 from Josh Berkus <josh(at)agliodbs(dot)com>
2010-06-22 19:28:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-22 19:45:57 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-22 20:32:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-23 04:20:02 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-23 20:56:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-23 21:22:35 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-22 17:04:43 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-06-24 11:54:16 from Greg Stark <gsstark(at)mit(dot)edu>
2010-06-24 14:40:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-22 17:30:55 from Florian Pflug <fgp(at)phlo(dot)org>
2010-06-24 01:14:33 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-24 11:04:37 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-11 09:18:46 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-11 13:44:18 from Andrew Chernow <ac(at)esilo(dot)com>
2010-02-11 17:23:03 from Kris Jurka <books(at)ejurka(dot)com>
Lists:
pgsql-hackers
Also, more importantly (from
http://www.slony.info/documentation/slonyadmin.html):
"A WAN outage (or flakiness of the WAN in general) can leave database
connections "zombied", and typical TCP/IP behaviour will allow those
connections to persist, preventing a slon restart for around two
hours. "
Regards,
Peter Geoghegan
In response to
pgsql-hackers by date
Next :From: Heikki LinnakangasDate: 2010-02-11 17:04:41Subject : Re: Re: [COMMITTERS] pgsql: Make standby server continuously
retry restoring the next WALPrevious :From : Alexey KlyukinDate : 2010-02-11 16:41:14Subject : Re: a common place for pl/perlu modules
