"henry" <henry(at)zen(dot)co(dot)za> writes:
> WRT the origional question: why is tcp_keepalives_idle being ignored
> (whether with SET or in postgresql.conf)? - ie, SHOW ALL says it's 0 no
> matter what I do.
I think you're looking at it in a session that's connecting over a Unix
socket. You need to be connected over TCP in order for the variable
to be meaningful. It'll read as 0 in a socket connection.
regards, tom lane