Re: tcp keepalives not sent during long query

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)