Re: BUG #1365: Loose connection in idle mode

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1365: Loose connection in idle mode
Дата
Msg-id 11106.1104340524@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #1365: Loose connection in idle mode  ("Jean Claude" <gaudetjc@neuf.fr>)
Список pgsql-bugs
"Jean Claude" <gaudetjc@neuf.fr> writes:
> I didn't found any related topic about timeout connection with a non
> activity of clients. In fact the server disconnect any client after ~10
> minutes of inactivity.

There is no disconnect timeout in Postgres.

This sort of thing has been reported before, and it's always been due to
overaggressive dropping of idle connections by a firewall in between the
clients and server.  NAT routers have to keep per-connection state about
the address mapping, and they will drop that state after some period of
no traffic.  10 minutes seems unreasonably short though.  I hope it's
configurable on your box.  If not, you can either buy a more reasonably
designed router, or tweak your clients so they do something at least
once every few minutes...

            regards, tom lane

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: ECPG CONNECT TO DEFAULT segfault
Следующее
От: "Winfried Maus"
Дата:
Сообщение: BUG #1357: Installation via Terminal Service