On Fri, 2024-06-14 at 11:22 -0400, Rui DeSousa wrote: > 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. That would surprise me. There is the parameter "client_connection_check_interval" exactly for that. Yours, Laurenz Albe
