Re: BUG #1365: Loose connection in idle mode - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1365: Loose connection in idle mode
Date
Msg-id 11106.1104340524@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1365: Loose connection in idle mode  ("Jean Claude" <gaudetjc@neuf.fr>)
List 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 by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: ECPG CONNECT TO DEFAULT segfault
Next
From: "Winfried Maus"
Date:
Subject: BUG #1357: Installation via Terminal Service