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 50BD15E46D6 for ; Wed, 18 Aug 2004 20:13:23 -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 89252-09 for ; Wed, 18 Aug 2004 23:13:28 +0000 (GMT) Received: from post5.inre.asu.edu (post5.inre.asu.edu [129.219.110.120]) by svr1.postgresql.org (Postfix) with ESMTP id 8442E5E46C7 for ; Wed, 18 Aug 2004 20:13:15 -0300 (ADT) Received: from conversion.post5.inre.asu.edu by asu.edu (PMDF V6.1-1X6 #30769) id <0I2O002010I1P2@asu.edu> for pgsql-admin@postgresql.org; Wed, 18 Aug 2004 16:13:13 -0700 (MST) Received: from smtp.asu.edu (smtp.asu.edu [129.219.110.107]) by asu.edu (PMDF V6.1-1X6 #30769) with ESMTP id <0I2O002BK0I16H@asu.edu> for pgsql-admin@postgresql.org; Wed, 18 Aug 2004 16:13:13 -0700 (MST) Received: from moroni.pp.asu.edu (moroni.pp.asu.edu [129.219.69.200]) by smtp.asu.edu (8.12.10/8.12.10/asu_smtp_relay, nullclient, tcp_wrapped) with ESMTP id i7INDC71016507 for ; Wed, 18 Aug 2004 16:13:13 -0700 (MST) Received: by moroni.pp.asu.edu (Postfix, from userid 500) id 0B0BAD3C; Wed, 18 Aug 2004 16:13:13 -0700 (MST) Date: Wed, 18 Aug 2004 16:13:12 -0700 From: David Bear Subject: tunneling through ssh To: pgsql-admin@postgresql.org Reply-To: David.Bear@asu.edu Message-id: <20040818231312.GA18227@asu.edu> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-disposition: inline User-Agent: Mutt/1.4.1i 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/170 X-Sequence-Number: 14565 I'm attempting to run pgsql through a tunnel. I'm using the default pg_hba.conf file for now which has the relevant information: ------------ local all all trust host all all 127.0.0.1 255.255.255.255 trust ------------ I assume this means that the back end will bind to 127.0.0.1:5432 since that seems to be the default port number. Yet, when trying to come through the tunnel I get this in my logs on the 'server' machine - the one running postgres backend. ----------- Aug 18 16:00:40 dbsrv1 sshd[41006]: error: connect_to ::1 port 5432: Connection refused Aug 18 16:00:40 dbsrv1 sshd[41006]: error: connect_to 127.0.0.1 port 5432: Connection refused Aug 18 16:00:40 dbsrv1 sshd[41006]: error: connect_to localhost port 5432: failed. ----------- Am I missing something obvious? -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing"