Re: pgAccess via ssh?

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