Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> Something very important to note: those settings do nothing unless the
> SO_KEEPALIVE option is turned on for the socket. AFAICT libpq does not
> enable this option, hence they (probably) have no effect.
AFAICS, it does so by default since 9.0.
regards, tom lane