Re: pgAccess via ssh?

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(at)syscor(dot)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
>
>