Connections over SSH tunnels closing after idle time

From: Jerry Sievers <jerry(at)jerrysievers(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Connections over SSH tunnels closing after idle time
Date: 2007-03-01 20:03:41
Message-ID: m3d53sloiq.fsf@mama.jerrysievers.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Curious if others have run into this;

Client side is Ubuntu Linux, server side is Solaris 10/ SPARC. Pg
version is 8.1.5.

Connecting to some machines requires tunneling through another host
that sits on 2 network interfaces.

ssh -n -N -N port:remote.host:5432 tunnelhost &

Connections work as expected but die after an idle period of an hour
or so. I see the socket on local side in TIME_WAIT state.

Doesn't seem like Postgres on Solaris will allow setting the
tcp_keepalive parameters. They are all set to zero presently and
cause error if a change is attempted.

Did try various combinations of the SSH TCP keepalive and ServerAlive
settings.

Any advice how to solve or better drill down to the exact problem is
much appreciated.

Thanks

--
-------------------------------------------------------------------------------
Jerry Sievers 732 365-2844 (work) Production Database Administrator
305 321-1144 (mobil WWW E-Commerce Consultant

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2007-03-01 20:12:48 hardware question - LSI MegaRaid 8480e
Previous Message Russ Brown 2007-03-01 19:51:30 Re: PostgreSQL primary (sequence) key issue (Ruby/Rails)