BUG #1365: Loose connection in idle mode
The following bug has been logged online:
Bug reference: 1365
Logged by: Jean Claude
Email address: gaudetjc@neuf.fr
PostgreSQL version: 8.0
Operating system: W2K
Description: Loose connection in idle mode
Details:
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. I try it with my program that i am developping, psql
and pgadmin III. All do the same after arround 10 minutes with inactivity
or
idle, the server diconnect by logging a message "unexpected EOF on client
connection".
Hoping to find out the reason or maybe a bug but all my project is in
standby now to fix this problem.
Thanks in advance for all your help
JClaude
"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