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