> 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
"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
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