On Fri, Mar 01, 2002 at 02:40:06PM -0500, Tom Lane wrote:
>
> I have been wondering about whether Bruce's problem is firewall
> misbehavior. In particular, if there's a NAT translation happening
> anywhere between his client and his server, then the firewall could
> break the connection by dropping that particular port mapping, which
> perhaps it might do if there's no activity for awhile. In this case,
> it might actually be that the default KEEPALIVE timeout of 2 hours is
> too long for us :-(. (RFC 1122 says that the timeout shall be
> configurable, but this requirement seems to be widely ignored.)
If that turns out to be the case, sending null queries periodically
should help some.
Jeroen