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

Re: TCP keepalive support for libpq

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:33:35
Message-ID: db471ace1002110833v708f7f60xd07e9534cdb3cf20@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
From the Slony-I docs (http://www.slony.info/documentation/faq.html) :

"Supposing you experience some sort of network outage, the connection
between slon and database may fail, and the slon may figure this out
long before the PostgreSQL  instance it was connected to does. The
result is that there will be some number of idle connections left on
the database server, which won't be closed out until TCP/IP timeouts
complete, which seems to normally take about two hours. For that two
hour period, the slon will try to connect, over and over, and will get
the above fatal message, over and over. "

Speaking as someone who uses Slony quite a lot, this patch sounds very
helpful. Why hasn't libpq had keepalives for years?

Regards,
Peter Geoghegan

In response to

Responses

pgsql-hackers by date

Next:From: Andrew ChernowDate: 2010-02-11 16:34:52
Subject: Re: TCP keepalive support for libpq
Previous:From: Kevin GrittnerDate: 2010-02-11 16:27:43
Subject: Re: TCP keepalive support for libpq

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