Hi All,
I have a very long running query that is not being terminated after a keep alive timeout event. The situation is that
theclient drops from the network, the servers’ tcp/ip stack drops the connection, and the Postgres query continues to
runwithout a network connection.
The given system is running on Linux and I’m being told this is expected behavior; however, that is not has not been my
experience. My preferred platform to run Postgres on is FreeBSD and in cases like this the Postgres session is also
terminatedonce the tcp/ip connection is dropped by the kernel.
Does anyone know if there is a difference on how Linux handles interrupted vs FreeBSD? I’ve actually used tcpdrop on
FreeBSDto terminate stubborn sessions that were not responding to pg_terminate_backend().
Is this really expected behavior on Linux?
-Rui.