| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Rui DeSousa <rui(dot)desousa(at)icloud(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Keepalive |
| Date: | 2024-06-14 17:47:11 |
| Message-ID: | e15acc58d2e0328f096a7d277ef862b5cc3cb271.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Hoover | 2024-06-14 18:19:06 | Re: Outage caused by query in IPC:MessageQueueReceive wait???? |
| Previous Message | Chris Hoover | 2024-06-14 17:02:54 | Re: Outage caused by query in IPC:MessageQueueReceive wait???? |