Thread: BUG #1365: Loose connection in idle mode

BUG #1365: Loose connection in idle mode

From
"Jean Claude"
Date:
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

Re: BUG #1365: Loose connection in idle mode

From
Tom Lane
Date:
"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