Re: close inactive client connection - Mailing list pgsql-general

From Scott Marlowe
Subject Re: close inactive client connection
Date
Msg-id dcc563d10909251218v322f72b9j9c51ec62d2720eac@mail.gmail.com
Whole thread Raw
In response to Re: close inactive client connection  ("Luiz Bernardi" <lb@cplinformatica.com>)
List pgsql-general
Are these machines communicating through a firewall?  Often firewalls
timeout idle tcp/ip connections.

On Fri, Sep 25, 2009 at 12:56 PM, Luiz Bernardi <lb@cplinformatica.com> wrote:
> 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@hogranch.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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



--
When fascism comes to America, it will be intolerance sold as diversity.

pgsql-general by date:

Previous
From: "Luiz Bernardi"
Date:
Subject: Re: close inactive client connection
Next
From: Scott Marlowe
Date:
Subject: Re: About logging