Re: TCP keepalive support for libpq

Поиск
Список
Период
Сортировка
Искать
От
Tollef Fog Heen
Тема
Re: TCP keepalive support for libpq
Дата
Msg-id
87mxzg8cpz.fsf@qurzaw.linpro.no
Ответ на
Список
Дерево обсуждения
TCP keepalive support for libpq Tollef Fog Heen <tollef.fog.heen@collabora.co.uk>
Re: TCP keepalive support for libpq Andrew Chernow <ac@esilo.com>
Re: TCP keepalive support for libpq daveg <daveg@sonic.net>
Re: TCP keepalive support for libpq Tollef Fog Heen <tollef.fog.heen@collabora.co.uk>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: TCP keepalive support for libpq Dimitri Fontaine <dfontaine@hi-media.com>
Re: TCP keepalive support for libpq Peter Geoghegan <peter.geoghegan86@gmail.com>
Re: TCP keepalive support for libpq Fujii Masao <masao.fujii@gmail.com>
Re: TCP keepalive support for libpq Peter Geoghegan <peter.geoghegan86@gmail.com>
Re: TCP keepalive support for libpq Fujii Masao <masao.fujii@gmail.com>
Re: TCP keepalive support for libpq Peter Geoghegan <peter.geoghegan86@gmail.com>
Re: TCP keepalive support for libpq Andrew Chernow <ac@esilo.com>
Re: TCP keepalive support for libpq Tollef Fog Heen <tollef.fog.heen@collabora.co.uk>
Re: TCP keepalive support for libpq Marko Kreen <markokr@gmail.com>
Re: TCP keepalive support for libpq Euler Taveira de Oliveira <euler@timbira.com>
Re: TCP keepalive support for libpq Fujii Masao <masao.fujii@gmail.com>
Re: TCP keepalive support for libpq Euler Taveira de Oliveira <euler@timbira.com>
Re: TCP keepalive support for libpq Magnus Hagander <magnus@hagander.net>
Re: TCP keepalive support for libpq Euler Taveira de Oliveira <euler@timbira.com>
Re: TCP keepalive support for libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq Fujii Masao <masao.fujii@gmail.com>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq Magnus Hagander <magnus@hagander.net>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq Magnus Hagander <magnus@hagander.net>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq Florian Pflug <fgp@phlo.org>
Re: TCP keepalive support for libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq Josh Berkus <josh@agliodbs.com>
Re: TCP keepalive support for libpq "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: TCP keepalive support for libpq Josh Berkus <josh@agliodbs.com>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq Fujii Masao <masao.fujii@gmail.com>
Re: TCP keepalive support for libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: TCP keepalive support for libpq Greg Stark <gsstark@mit.edu>
Re: TCP keepalive support for libpq Tom Lane <tgl@sss.pgh.pa.us>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq Magnus Hagander <magnus@hagander.net>
Re: TCP keepalive support for libpq Magnus Hagander <magnus@hagander.net>
Re: TCP keepalive support for libpq Robert Haas <robertmhaas@gmail.com>
Re: TCP keepalive support for libpq Magnus Hagander <magnus@hagander.net>
Re: TCP keepalive support for libpq Andrew Chernow <ac@esilo.com>
Re: TCP keepalive support for libpq Kris Jurka <books@ejurka.com>
Re: TCP keepalive support for libpq Fujii Masao <masao.fujii@gmail.com>
Re: TCP keepalive support for libpq Magnus Hagander <magnus@hagander.net>
Re: TCP keepalive support for libpq Tollef Fog Heen <tollef.fog.heen@collabora.co.uk>
]] daveg 

| I disagree. I have clients who have problems with leftover client connections
| due to server host failures. They do not write apps in C. For a non-default
| change to be effective we would need to have all the client drivers, eg JDBC,
| psycopg, DBD-DBI, and the apps like psql make changes to turn it on. Adding
| this option as a non-default will not really help.

FWIW, this is my case.  My application uses psycopg, which provides no
way to get access to the underlying socket.  Sure, I could hack my way
around this, but from the application writer's point of view, I have a
connection that I expect to stay around and be reliable.  Whether that
connection is over a UNIX socket, a TCP socket or something else is
something I would rather not have to worry about; it feels very much
like an abstraction violation.

-- 
Tollef Fog Heen 
UNIX is user friendly, it's just picky about who its friends are

В списке pgsql-hackers по дате отправления
От: Priit Laes
Дата:
От: Robert Haas
Дата:
FAQ