pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David.Bear@asu.edu
Cc: pgsql-admin@postgresql.org
Subject: Re: long term persistent tunnels
Date: Thu, 19 Aug 2004 20:38:52 -0400
Message-ID: <14201.1092962332@sss.pgh.pa.us> (raw)
In-Reply-To: <20040819232930.GG23172@asu.edu>
References: <20040819232930.GG23172@asu.edu>

David Bear <David.Bear@asu.edu> writes:
> Asume I have another server called web1 that will be connecting to db1
> for data base operations.  If I setup an ssh tunnel should I be aware
> of any problems with 1) spontaneously dropped connections...2) long
> term time out -- 3)other?

In theory the connection won't be dropped until the client drops it or
the database is shut down.

In practice, the only major problems I've heard about have to do with
connections that go through a NAT (address-mapping) firewall.  A NAT
firewall has to keep a table of open connections, and some of them seem
to drop their entries for idle connections with unseemly haste (like
less than the RFC-mandated timeouts).

If you've got one of these suckers to deal with, the only solution is to
make sure there's some activity on the connection at least once every
few minutes.

If web1 and db1 are on the same LAN then you probably have nothing to
fear.

			regards, tom lane



view thread (2+ messages)

Message-ID: <14201.1092962332@sss.pgh.pa.us>
Permalink:  ../14201.1092962332@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/14201.1092962332@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, David.Bear@asu.edu
  Subject: Re: long term persistent tunnels
  In-Reply-To: <14201.1092962332@sss.pgh.pa.us>
  References: <20040819232930.GG23172@asu.edu> <14201.1092962332@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox