Re: Keepalive - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: Keepalive
Date
Msg-id 2102D9CA-8FBD-49FE-821D-D74987442204@icloud.com
Whole thread Raw
In response to Re: Keepalive  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin

> On Jun 14, 2024, at 1:47 PM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> 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


I retested the spinner() function on Linux with the client_connection_check_interval set and it now terminates the
spinner()function.   

Thanks!
Rui.


pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Logical replication from PostgreSQL 10.23 to 16.3, last two big tables (getting synced) just keep growing
Next
From: Tom Lane
Date:
Subject: Re: Keepalive