Skip site navigation (1) Skip section navigation (2)

Re: pgAccess via ssh?

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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
> 
>

In response to

pgsql-novice by date

Next:From: Jim WilsonDate: 2004-09-02 17:45:11
Subject: Re: [NOVICE] pgAccess via ssh?
Previous:From: Ron St-PierreDate: 2004-09-02 17:34:59
Subject: Re: pgAccess via ssh?

pgsql-general by date

Next:From: Jim WilsonDate: 2004-09-02 17:45:11
Subject: Re: [NOVICE] pgAccess via ssh?
Previous:From: Ron St-PierreDate: 2004-09-02 17:34:59
Subject: Re: pgAccess via ssh?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group