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
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) |