Re: Connection idle broken - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Connection idle broken
Date
Msg-id dcc563d10711270709x7b31b42fs8efa4c8fbc034969@mail.gmail.com
Whole thread Raw
In response to Connection idle broken  (Fernando Xavier <fernandoxavier@yahoo.com>)
List pgsql-general
On Nov 27, 2007 8:33 AM, Fernando Xavier <fernandoxavier@yahoo.com> wrote:
> Hi,
>
> I have trouble with my  java application. Since i change the network configuration, the postgresql idle connections
brokenafter 10 minutes. (i set authentication_timeout = 600 in postgresql.conf). 
>
> My network:
>
> 192.168.1.1 (postgresql server and gateway server)
> 192.168.0.1 (linksys wireless router)
> 192.168.0.x (clients)
>
> How i make my idle connections alive for long time?

You can try lowering your tcp_keepalive settings.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: autovacuum process blocks without reporting a deadlock
Next
From: "Thomas Chille"
Date:
Subject: Re: autovacuum process blocks without reporting a deadlock