Hi All, I have a very long running query that is not being terminated after a keep alive timeout event. The situation is that the client drops from the network, the servers’ tcp/ip stack drops the connection, and the Postgres query continues to run without 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 terminated once 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 FreeBSD to terminate stubborn sessions that were not responding to pg_terminate_backend(). Is this really expected behavior on Linux? -Rui.
