Re: tcp keepalives not sent during long query

From: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: tcp keepalives not sent during long query
Date: 2022-12-15 13:04:43
Message-ID: CAEzk6fcMqWKezYEOL3g8tm5F=ayXXNrkh-ZZ2fq8pH0oSUFOrQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 15 Dec 2022 at 07:31, Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:
>
> wbloos=# set tcp_keepalives_idle=120;
> SET
> wbloos=# show tcp_keepalives_idle;
> tcp_keepalives_idle
> ---------------------
> 0

Are you connected in this psql session via tcp or unix domain socket?

"In sessions connected via a Unix-domain socket, this parameter is
ignored and always reads as zero."

Geoff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Willy-Bas Loos 2022-12-15 14:02:26 Re: tcp keepalives not sent during long query
Previous Message Willy-Bas Loos 2022-12-15 12:24:09 Re: tcp keepalives not sent during long query