Re: pgAccess via ssh? - Mailing list pgsql-novice

From Oliver Fromme
Subject Re: pgAccess via ssh?
Date
Msg-id 200409031109.i83B9UdH096361@lurza.secnetix.de
Whole thread Raw
In response to Re: pgAccess via ssh?  (Ron St-Pierre <rstpierre@syscor.com>)
Responses Re: pgAccess via ssh?
Re: pgAccess via ssh?
List pgsql-novice
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 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.

 > 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

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: pgAccess via ssh?
Next
From: Mike
Date:
Subject: Re: pgAccess via ssh?