On Wed, Dec 14, 2022 at 6:38 PM Tom Lane <tgl@xxxxxxxxxxxxx> 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)
SET
wbloos=# show tcp_keepalives_idle;
tcp_keepalives_idle
---------------------
0
(1 row)
Willy-Bas Loos