From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Luiz Bernardi <lb(at)cplinformatica(dot)com> |
Cc: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: close inactive client connection |
Date: | 2009-09-25 19:18:04 |
Message-ID: | dcc563d10909251218v322f72b9j9c51ec62d2720eac@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)cplinformatica(dot)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(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
>
>
> --
> 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
>
--
When fascism comes to America, it will be intolerance sold as diversity.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-09-25 19:24:26 | Re: About logging |
Previous Message | Luiz Bernardi | 2009-09-25 18:56:55 | Re: close inactive client connection |