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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
