Re: proposal: setKeepAlive - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: proposal: setKeepAlive
Date
Msg-id 1700.1202598102@sss.pgh.pa.us
Whole thread Raw
In response to Re: proposal: setKeepAlive  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: proposal: setKeepAlive
Next
From: Gregory Stark
Date:
Subject: Re: proposal: setKeepAlive