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

OT: Was Re: pgAccess via ssh?

From: Tim Pushor <timp(at)crossthread(dot)com>
To: Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de>
Cc: 1100100(at)gmail(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: OT: Was Re: pgAccess via ssh?
Date: 2004-09-02 15:07:05
Message-ID: 41373719.5020608@crossthread.com (view raw or flat)
Thread:
Lists: pgsql-novice
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
>
>  
>


In response to

pgsql-novice by date

Next:From: MikeDate: 2004-09-02 15:24:18
Subject: Re: pgAccess via ssh?
Previous:From: Oliver FrommeDate: 2004-09-02 14:58:01
Subject: Re: pgAccess via ssh?

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