X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 922145E46C1 for ; Thu, 19 Aug 2004 21:38:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 51898-08 for ; Fri, 20 Aug 2004 00:38:51 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id D484D5E46C7 for ; Thu, 19 Aug 2004 21:38:49 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i7K0cqCS014202; Thu, 19 Aug 2004 20:38:52 -0400 (EDT) To: David.Bear@asu.edu Cc: pgsql-admin@postgresql.org Subject: Re: long term persistent tunnels In-reply-to: <20040819232930.GG23172@asu.edu> References: <20040819232930.GG23172@asu.edu> Comments: In-reply-to David Bear message dated "Thu, 19 Aug 2004 16:29:30 -0700" Date: Thu, 19 Aug 2004 20:38:52 -0400 Message-ID: <14201.1092962332@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/187 X-Sequence-Number: 14582 David Bear 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