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 по дате отправления: