Re: [GENERAL] How to close dead connections immediately

2006-04-25 Thread Andrus
> PG *will* close the connection immediately if it receives any > notification of connection drop from the client. If it's not seeing > one, that suggests something wrong in your network infrastructure. > I'd suggest fixing the problem rather than kluging the symptom. I have W2K server running al

Re: [GENERAL] How to close dead connections immediately

2006-04-24 Thread Tom Lane
"Andrus" <[EMAIL PROTECTED]> writes: > My ODBC client uses single connection to Postgres 8.1.3 server in W2K > In case of TCP error it closes connection and re-opens it. > ... > Is it possible to force postgres to close dead connections immediately, not > after 6 hours ? PG *will* close the conne

[GENERAL] How to close dead connections immediately

2006-04-24 Thread Andrus
My ODBC client uses single connection to Postgres 8.1.3 server in W2K In case of TCP error it closes connection and re-opens it. Unfortunately, in server status window I see a number of connections from same IP address. In log file I have lines like 2006-04-24 01:24:41 oksana 188.16.34.194 idle