Willy-Bas Loos <willybas(at)gmail(dot)com> writes:
> 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)
That's the behavior I'd expect on a local (Unix-socket) connection
... you sure you're doing this from one of the problematic clients?
regards, tom lane