Thread: pgsql revision question

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.

Thanks for your help.

Mike

P.S. -- heh, there appears to be some problem at sourceforge this
morning.  The link to download the pgaccess.zip file is dead as of
10:20 am EST.  Hmm, maybe I should move on to check out pgAdmin.

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

--
Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.

"Python tricks" is a tough one, cuz the language is so clean. E.g.,
C makes an art of confusing pointers with arrays and strings, which
leads to lotsa neat pointer tricks; APL mistakes everything for an
array, leading to neat one-liners; and Perl confuses everything
period, making each line a joyous adventure <wink>.
        -- Tim Peters

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
>
>
>

Oliver,

Thanks so much for your reply.
I appreciate the guidance.

I'm on my way to OpenSSH right now.

Take care,

Mike

>
> 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
>