The following bug has been logged online:

Bug reference: 1365
Logged by: Jean Claude
Email address: gaudetjc (AT) neuf (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

"Jean Claude" <gaudetjc (AT) neuf (DOT) fr> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org