Re: psql hanging

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: psql hanging
Дата
Msg-id dcc563d10709051353w2320464eob0d4ecc589ff4d88@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql hanging  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
On 9/5/07, Martijn van Oosterhout <kleptog@svana.org> wrote:
> On Wed, Sep 05, 2007 at 10:44:20AM -0700, Trevor Talbot wrote:
> > Unless psql is turning on keepalive or similar, or the OS is forcing
> > it on by default, there are no timeouts for idle TCP connections.  If
> > the command was transported to the server successfully and psql was
> > just waiting for a result, the connection is idle and nothing will
> > happen if the server end suddenly goes away.
>
> Well, any TCP implementation has to support keepalives and generally
> they are turned on by default, but to something like 2 days. Anything
> months old must be caused by something else (overzealous firewall
> dropping the RST packets in response to the keepalives?).

The default for RHEL3 and 4 is 2 hours.

В списке pgsql-general по дате отправления:

Предыдущее
От: "Rodrigo De León"
Дата:
Сообщение: Re: now() vs current_user
Следующее
От: Josh Trutwin
Дата:
Сообщение: Querying database for table pk - better way?