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 idleLOG: could not receive data
from client: No connection could be made because the target machine actively
refused it.
2006-04-24 01:24:41 oksana 188.16.34.194 idleLOG: unexpected EOF on client
connection
2006-04-24 01:24:41 oksana 188.16.34.194 idleLOG: disconnection: session
time: 6:19:20.54 user=oksana database=mydb host=188.16.34.194 port=33625
This occurs in 1:24 in midnight while user has exited my application a
number of hours ago.
How to prevent dead connections ?
My server and client are in Windows and TCP_KEEPALIVE parameters have
default settings.
Is it possible to force postgres to close dead connections immediately, not
after 6 hours ?
Andrus.