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.