I use SSH all the time to tunnel shell and X-windows traffic. I think I
remember getting a local psql connection to a remote database going following
the instruction s in section 3.8 of the Adminstrators guide but its been a
little bit.
If no one else response I'll take a wack at it and send in a step-by-step example.
As a note though, generally, I just SSH into the box that has the database and
then run psql from there or open up pgaccess.
Quoting "Nigel J. Andrews" <nandrews@investsystems.co.uk>:
> On Thu, 15 May 2003, Fernando Flores Prior wrote:
>
> > Nice !
> >
> > It works just great. This will be a fine asset for the thechdocs.
> >
> > -Fernando
> >
> >
> > At 08:49 p.m. 14/05/2003 -0400, Matthew Nuzum wrote:
> > >This thread got my curiosity going, so I endeavored to try to get it
> working
> > >and am happy to say that it was very easy to tunnel a postgresql
> connection
> > >over ssh.
> > >
> > >Here's what I did...
> >
>
> Yes, smashing. Anyone got some similar destructions for SSH tunneling with
> SSH
> Communications Corp's (www.ssh.com) stuff. I've tried pointing and clicking
> in
> the appropiate dialog several times now and the best I can get is a notice
> from
> the firewall on the system that my test connection has connected to the
> localhost but get a connection refused and don't see any network traffic out
> to
> the server. I can ssh into the server and get a shell (just to clarify that
> point).
>
>
> --
> Nigel J. Andrews
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com