Re: close inactive client connection

hi John

I have no idea of what may be happening. The system opens a connection
and communicate normally. But after an idle time, it loses the
connection and new transactions return with error.

16/09/2009 13:39:14 - SQL Error: no connection to the server
16/09/2009 13:39:14 - SQL Error: connection not open

At this point he reconnects, the server creates a new connection that
behaves exactly like the previous one.

--
Luiz Agnaldo Bernardi
Fone 41 36755756
     41 99979849

On Fri, 25 Sep 2009 10:03:20 -0700
 John R Pierce <pierce(at)hogranch(dot)com> wrote:
> Luiz Bernardi wrote:
>> I am developing a system, using the ZeosLib, which maintains a
>>permanent connection to the database.
>>
>> When the client loses the connection, the server does not recognize
>>this and keeps the connection as if it were active. When the client
>>attempts to reconnect, the server creates a new connection and the
>>previous remains active.
>
> how does this happen ?   TCP connections don't just wander off and
>get lost.
>
>> This has caused an excessive increase in the number of active
>>connections and hampered the use of the system.
>>
>> Have any way or setting to make postgres close idle connections?
>
> first, you'd have to identify that they were in fact 'lost' and not
>just idle.   we have apps that open a socket to postgres, issue some
>commands, then sometimes sit for hours before more commands are
>issued.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general