Обсуждение: 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