Thread: Pgadmin + ssh

Pgadmin + ssh

From
Master ProPG
Date:
Hi,

i'm using pgadmin tunneling through ssh,
anyone knows if there is a way to connect directly
from pgadmin using tunneling without use a shell interface + ssh?

thanks.

Re: Pgadmin + ssl (was ssh)

From
Jean-Michel Pouré
Date:
Le jeudi 27 août 2009 à 11:47 -0300, Master ProPG a écrit :
> anyone knows if there is a way to connect directly
> from pgadmin using tunneling without use a shell interface + ssh?

Please send your question to PostgreSQL users.

You can use PostgreSQL and pgAdmin3 with direct SSL connection.

pg_hba.conf:
hostssl all         username     0.0.0.0/0              md5
I restrict to some IP and set firewalling on.

postgresql.conf:
ssl = true

pgAdmin3
configure a connection with "require SSL"

In case of further question, register postgresql users.

Kind regards,
Jean-Michel

Attachment

Re: Pgadmin + ssh

From
Guillaume Lelarge
Date:
Le jeudi 27 août 2009 à 16:47:37, Master ProPG a écrit :
> Hi,
>
> i'm using pgadmin tunneling through ssh,
> anyone knows if there is a way to connect directly
> from pgadmin using tunneling without use a shell interface + ssh?
>

No, AFAIK, there's no way to do this without creating manually the tunnel. But
I would love to get that in pgAdmin.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

Re: Pgadmin + ssh

From
Magnus Hagander
Date:
2009/8/27 Guillaume Lelarge <guillaume@lelarge.info>:
> Le jeudi 27 août 2009 à 16:47:37, Master ProPG a écrit :
>> Hi,
>>
>> i'm using pgadmin tunneling through ssh,
>> anyone knows if there is a way to connect directly
>> from pgadmin using tunneling without use a shell interface + ssh?
>>
>
> No, AFAIK, there's no way to do this without creating manually the tunnel. But
> I would love to get that in pgAdmin.

+1 for that being a useful feature :-) I'm sure you'll add a ticket in
a minute if you haven't already :D

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Re: Pgadmin + ssh

From
Guillaume Lelarge
Date:
Le jeudi 27 août 2009 à 17:22:53, Magnus Hagander a écrit :
> 2009/8/27 Guillaume Lelarge <guillaume@lelarge.info>:
> > Le jeudi 27 août 2009 à 16:47:37, Master ProPG a écrit :
> >> Hi,
> >>
> >> i'm using pgadmin tunneling through ssh,
> >> anyone knows if there is a way to connect directly
> >> from pgadmin using tunneling without use a shell interface + ssh?
> >
> > No, AFAIK, there's no way to do this without creating manually the
> > tunnel. But I would love to get that in pgAdmin.
>
> +1 for that being a useful feature :-) I'm sure you'll add a ticket in
> a minute if you haven't already :D

Done.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com