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

Re: pgAccess via ssh?

From: <operationsengineer1(at)yahoo(dot)com>
To: Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de>,Ron St-Pierre <rstpierre(at)syscor(dot)com>
Cc: Mike <1100100(at)gmail(dot)com>,pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: pgAccess via ssh?
Date: 2004-09-05 18:45:34
Message-ID: 20040905184534.62338.qmail@web52403.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
this purports to explain how to connect via ssh (haven't tried it)...
 
http://www.scosug.org/materials/20020623/
SSH/OpenSSH method:Use the -L option to ssh to create a tunnel between the client system and the remote system.  This is transparent to PostgreSQL, which will see the connection as coming from its local system.  You must account for this in your pg_hba.conf file.

Example:
First, set up the tunnel in one terminal...
ssh -L 4001:remotehost:5432 user(at)remotehost

Then, in another terminal, use psql to connect to the local port (4001) specified in the ssh command:
psql -h localhost -p 4001 mydatabase

Assuming this works, can one then use pgaccess to to "tunnel" through the ssh tunnel?    Is just changing the port to 4001 instead of 5432 enough to get access to the remote db through pgaccess' login screen?
 
tia...

Oliver Fromme <olli(at)lurza(dot)secnetix(dot)de> wrote:

Ron St-Pierre wrote:
> You don't need to putty into the box to use pgAdmin, you just tell 
> pgAdmin the ip address, user (postgres),
> and password (unless it's trusted). This works as long as you've allowed 
> access from your remote ip address
> eg in /data/pg_hba.conf you might have something like this
> host all all 24.233.244.45 255.255.255.255 trust
> this line trusts all users connecting from 24.233.244.45, so for example 
> pgAdmin could gain db access.
> 
> > No Cygwin necessary for this situation?
> > 
> No cygwin needed.

However, in that case the DB connection will _not_ be
through ssh, so it will be unencrypted and insecure.

From Mike's initial mail I got the impression that he
wanted the connection to the PostgreSQL server to go
through ssh (which is basically a good thing, because
you get ssh's authentication and encryption features).

Best regards
Oliver

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

> Can the denizens of this group enlighten me about what the
> advantages of Python are, versus Perl ?
"python" is more likely to pass unharmed through your spelling
checker than "perl".
-- An unknown poster and Fredrik Lundh

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

		
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!

In response to

Responses

pgsql-novice by date

Next:From: Oliver FrommeDate: 2004-09-06 10:26:16
Subject: Re: pgAccess via ssh?
Previous:From: operationsengineer1Date: 2004-09-05 07:29:47
Subject: Finding Cygwin Packages with Older PGSQL Versions

pgsql-general by date

Next:From: EricDate: 2004-09-05 18:48:42
Subject: RAD with postgreSQL
Previous:From: Mike NolanDate: 2004-09-05 18:23:18
Subject: Re: How to determine a database is intact?

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