OT: Was Re: pgAccess via ssh?

Putty does support forwarding arbitrary TCP connections - I use it all
the time (v 0.55).

Tim

Oliver Fromme wrote:

>Mike wrote:
> > I have an ssh server set up on my home linux box and can access my
> > postgresql server and database using puTTY from remote locations.
> >
> > Is it possible to access the postgresql database on the home linux box
> > by way of ssh, and then use pgAccess in conjunction with ssh to run
> > queries, etc.
>
>Yes, it is possible.  The SSH protocol supports tunneling
>of TCP connections.  As far as I know, putty does not
>support that feature, but OpenSSH does.  As it seems you
>have a Windows machine (not UNIX or Linux), the easiest
>option is probably to install Cygwin which comes with
>OpenSSH.
>
>The follwoing command will establish such a tunnel:
>ssh -L 5432:127.0.0.1:5432 your.host.com
>
>Then you can use pgAccess (or other clients) to connect to
>port 5432 on localhost, which is forwarded through the ssh
>connection to port 5432 on your home machine.  You can use
>a different local port number if necessary.  For the Post-
>greSQL server, the connections appear to be originating
>from localhost, so the same authentication applies.
>
>Best regards
>   Oliver
>
>
>