Re: How to use SSH tunnels with pgAdmin?

From: "Ken Winter" <ken(at)sunward(dot)org>
To: "'Wolfgang Pasche'" <pasche(dot)wolfgang(at)kabelmail(dot)de>
Cc: "'Josh Berkus'" <josh(at)agliodbs(dot)com>, "'pgAdmin Support List'" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: How to use SSH tunnels with pgAdmin?
Date: 2010-03-11 21:35:00
Message-ID: E43E58A2AD1446728B68BB3FBEA110BB@KenIBM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Thanks, Wolfgang. I'll give that a try when I get a chance.

> -----Original Message-----
> From: Wolfgang Pasche [mailto:pasche(dot)wolfgang(at)kabelmail(dot)de]
> Sent: Thursday, March 11, 2010 2:41 PM
> To: Ken Winter
> Cc: 'Josh Berkus'; 'pgAdmin Support List'
> Subject: Re: [pgadmin-support] How to use SSH tunnels with pgAdmin?
>
> Hi Ken,
>
> a possibly not too bad workaround could be to config a Putty session with
> automatic login, no shell,
> minimized window (such as 2 lines, 20 chars), using a key instead of
> password for authentication
> (config window SSH/auth). Then create a shortcut which calls Putty with a
> session parameter.
> In this case, you only have to double click the shortcut icon and wait
> some seconds before using
> PgAdmin. The complete session start incl. login is done automatically.
>
> Regards
> Wolfgang Pasche
> Hamburg, Germany
>
>
> Ken Winter schrieb:
> > I've been using a tunneled connection (with a keep-alive signal every 15
> > sec) for a couple of weeks now, and it's solid as a rock.
> >
> > It's inconvenient to have to manually bring up PuTTY and log in every
> time
> > before using pgAdmin, but I hear that you have an automatic connection
> > feature on your to-do list; that would be very welcome.
> >
> > ~ Thanks to all for your help
> > ~ Ken
> >
> >> -----Original Message-----
> >> From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-
> >> owner(at)postgresql(dot)org] On Behalf Of Josh Berkus
> >> Sent: Saturday, February 27, 2010 3:46 PM
> >> To: Ken Winter
> >> Cc: pgAdmin Support List
> >> Subject: Re: [pgadmin-support] How to use SSH tunnels with pgAdmin?
> >>
> >>
> >>> My problem is, I don't know how to set up pgAdmin to use my SSH
> package
> >>> (PuTTY). At least I think that's my problem. Can you help?
> >> If regular port 5432 connections to your server are being dropped
> >> frequently, then I'm not sure an SSH tunneled connection is going to
> >> help you. Any network flakiness would affect it equally.
> >>
> >> Unless the connections are being dropped for some other reason?
> >>
> >> --Josh Berkus
> >>
> >>
> >> --
> >> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> >> To make changes to your subscription:
> >> http://www.postgresql.org/mailpref/pgadmin-support
> >
> >

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Josh Berkus 2010-03-11 23:42:33 Re: Installing debugger?
Previous Message Vinicius Borges 2010-03-11 19:48:15 Problems with wxWidgets 2.6