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

From Mike
Subject Re: pgAccess via ssh?
Date
Msg-id 8ca4228204090210417d14725d@mail.gmail.com
Whole thread Raw
In response to Re: pgAccess via ssh?  (Ron St-Pierre <rstpierre@syscor.com>)
List pgsql-novice
Ron,

Shuper-Shweet.
As soon as I can peel myself away from other administrative duties,
I'm going to get this fired up.

Thanks for taking the time.

Mike

On Thu, 02 Sep 2004 10:34:59 -0700, Ron St-Pierre <rstpierre@syscor.com> wrote:
> Mike wrote:
>
> >Hi Ron,
> >
> >I've got the puTTY via ssh working well.
> >So, you're saying I can puTTY via ssh to connect to the linux box and
> >postgresql server, and then start pgAdminIII  and I'll be able to use
> >the GUI app. with the postgres database.
> >
> Once you putty into the box (assuming you are user postgres, or whoever
> owns the postmaster), you
> can psql into the database eg psql myDB
> 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.
>
> >
> >Please let me know if I'm understanding this correctly when you have a moment.
> >
> >Thanks for your guidance and input.
> >
> >Mike
> >
> >
> Ron
>
>

pgsql-novice by date:

Previous
From: Ron St-Pierre
Date:
Subject: Re: pgAccess via ssh?
Next
From:
Date:
Subject: Re: pgAccess via ssh?