Re: hung postmaster when client machine dies?

Поиск
Список
Период
Сортировка
От Peter Galbavy
Тема Re: hung postmaster when client machine dies?
Дата
Msg-id 008001c3ed68$d2810b80$24e0a8c0@sonylaptop
обсуждение исходный текст
Ответ на Re: hung postmaster when client machine dies?  ("Goulet, Dick" <DGoulet@vicr.com>)
Список pgsql-admin
Goulet, Dick wrote:
> Hope you don't mind if I disagree.  Most OS's that have a tcp/ip
> layer also have a parameter therein called tcp_keep_alive.  They also
> set this parameter to infinity.  The purpose of tcp_keep_alive is to
> have the OS kernel periodically verify that all tcp/ip connections it
> is managing are still functioning every so often.  Basically the OS
> sends a probe packet down the line to the to the client machine.  If
> it bounces back the connection is dead & the OS can do what it has
> to, which will then notify postmaster just like you manually did.
> I'd contact your OS vendor for information of what tcp_keep_alive is
> set to by default and how you can change it.

On the other hand I suggest that you *do not* change this value, even if you
know how, without being very careful understanding what it means.

Changing the system-wide TCP KA time can have unforseen effects on other,
unrelated functions of the systems concerned.

This is simply why most long lived protocols layered over TCP also tend to
have their own keep alive PDUs.

Peter


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Scripts Importing and Authentication
Следующее
От: "Peter Galbavy"
Дата:
Сообщение: Re: hanging for 30sec when checkpointing