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 D28C05E46C1 for ; Wed, 18 Aug 2004 20:21:16 -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 93685-10 for ; Wed, 18 Aug 2004 23:21:21 +0000 (GMT) Received: from polaris.pinpointresearch.com (66-7-238-130.cust.telepacific.net [66.7.238.130]) by svr1.postgresql.org (Postfix) with ESMTP id 21E1D5E46C0 for ; Wed, 18 Aug 2004 20:21:11 -0300 (ADT) Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 3E6ED10418; Wed, 18 Aug 2004 16:21:24 -0700 (PDT) From: Steve Crawford Organization: Pinpoint Research To: David.Bear@asu.edu, pgsql-admin@postgresql.org Subject: Re: tunneling through ssh Date: Wed, 18 Aug 2004 16:21:24 -0700 User-Agent: KMail/1.5.1 References: <20040818231312.GA18227@asu.edu> In-Reply-To: <20040818231312.GA18227@asu.edu> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200408181621.24097.scrawford@pinpointresearch.com> 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/171 X-Sequence-Number: 14566 On Wednesday 18 August 2004 4:13 pm, David Bear wrote: > 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? Is PG set to accept tcp/ip connections? Check postgresql.conf for: tcpip_socket=true 127.0.0.1 is connecting through tcp/ip, not local domain sockets. Cheers, Steve