tunneling through ssh - Mailing list pgsql-admin

From David Bear
Subject tunneling through ssh
Date
Msg-id 20040818231312.GA18227@asu.edu
Whole thread Raw
Responses Re: tunneling through ssh
List pgsql-admin
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"

pgsql-admin by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [HACKERS] SRPM for 8.0.0 beta?
Next
From: Steve Crawford
Date:
Subject: Re: tunneling through ssh