Re: tcp keepalives not sent during long query

Nice query, i keep learning new stuff here.
Anyway, that shows the correct line (80) in the config file, but the wrong
value.
Namely 0, where the config file has 120

On Thu, Dec 15, 2022 at 12:37 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> 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(at)sss(dot)pgh(dot)pa(dot)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
>

--
Willy-Bas Loos