Re: tcp keepalives not sent during long query

On Thu, 2022-12-15 at 08:31 +0100, Willy-Bas Loos wrote:
> On Wed, Dec 14, 2022 at 6:38 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > It'd be worth doing
> > 
> > show tcp_keepalives_idle;
> 
> Wow, you're right! It's in the postgresql.conf but it isn't set when I reload the server
> A restart also doesn't do it and even doing SET tcp_keepalives_idle=120; doesn't work.
> It gives me a confirmation, but then when I SHOW the value, it gives me 0.
> 
> wbloos=# set tcp_keepalives_idle=120;
> SET
> wbloos=# show tcp_keepalives_idle;
>  tcp_keepalives_idle 
> ---------------------
>  0
> (1 row)

One good way to debug this is

  SELECT setting, source, sourcefile, sourceline
  FROM pg_settings
  WHERE name = 'tcp_keepalives_idle';

That will tell you from where you get the parameter value.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com