From: | Mike <1100100(at)gmail(dot)com> |
---|---|
To: | Ron St-Pierre <rstpierre(at)syscor(dot)com> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: pgAccess via ssh? |
Date: | 2004-09-02 17:41:30 |
Message-ID: | 8ca4228204090210417d14725d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general 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(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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Wilson | 2004-09-02 17:45:11 | Re: [NOVICE] pgAccess via ssh? |
Previous Message | Ron St-Pierre | 2004-09-02 17:34:59 | Re: pgAccess via ssh? |
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Wilson | 2004-09-02 17:45:11 | Re: [NOVICE] pgAccess via ssh? |
Previous Message | Ron St-Pierre | 2004-09-02 17:34:59 | Re: pgAccess via ssh? |