Skip site navigation (1) Skip section navigation (2)

tunneling through ssh

From: David Bear <David(dot)Bear(at)asu(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: tunneling through ssh
Date: 2004-08-18 23:13:12
Message-ID: 20040818231312.GA18227@asu.edu (view raw or flat)
Thread:
Lists: 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"

Responses

pgsql-admin by date

Next:From: Steve CrawfordDate: 2004-08-18 23:21:24
Subject: Re: tunneling through ssh
Previous:From: Simon RiggsDate: 2004-08-18 21:28:12
Subject: Re: NOT LOGGED options (was Point in Time Recovery )

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group