Re: proposal: setKeepAlive

Oliver Jowett <oliver@opencloud.com> writes:
> People seem to like to put stateful firewalls with low connection
> activity timeouts between their DB server and client. We get regular
> traffic on the list from people who see connections get reset on their
> first use after a long idle period. Presumably TCP keepalive would help
> in some of these cases.

There's certainly a use-case there, but we already provide TCP keepalive
functionality on the server side, which should be good enough to hold
open a NAT connection.  It's not clear to me why we need keepalive
probes coming from the client side too.

            regards, tom lane