Thread: Running pgadmin on Windows 7; SSL tunneling

Running pgadmin on Windows 7; SSL tunneling

From
Chris Benenati
Date:
<div class="WordSection1"><p class="MsoNormal">I tried running pgAdmin 3, both versions 1.18.1 (the latest version
availablefor Win 7 according to the notes on the download page) and 1.22.1 (the latest version).  Both crash on my
Windows7 system when I try to do almost anything.  Has anybody had any better luck.<p class="MsoNormal"> <p
class="MsoNormal">Ialso tried pgAdmin 4, Beta 2, which is documented as working for Win 7.  However, the dialog for
creatinga Server connection does not have support for SSL tunneling, which is required to get to the database.  Is SSL
tunnelingno longer supported?</div> 

Re: Running pgadmin on Windows 7; SSL tunneling

From
Chris Benenati
Date:
And now I'm having the same problems with 1.22.1 on Win 10

On Tue, Jun 28, 2016 at 3:33 PM, Chris Benenati <cbenenati@impactnw.org> wrote:

I tried running pgAdmin 3, both versions 1.18.1 (the latest version available for Win 7 according to the notes on the download page) and 1.22.1 (the latest version).  Both crash on my Windows 7 system when I try to do almost anything.  Has anybody had any better luck.

 

I also tried pgAdmin 4, Beta 2, which is documented as working for Win 7.  However, the dialog for creating a Server connection does not have support for SSL tunneling, which is required to get to the database.  Is SSL tunneling no longer supported?


Re: Running pgadmin on Windows 7; SSL tunneling

From
Stephen Cook
Date:
On 2016-06-28 21:40, Chris Benenati wrote:
> And now I'm having the same problems with 1.22.1 on Win 10
> 
> On Tue, Jun 28, 2016 at 3:33 PM, Chris Benenati <cbenenati@impactnw.org
> <mailto:cbenenati@impactnw.org>> wrote:
> 
>     I tried running pgAdmin 3, both versions 1.18.1 (the latest version
>     available for Win 7 according to the notes on the download page) and
>     1.22.1 (the latest version).  Both crash on my Windows 7 system when
>     I try to do almost anything.  Has anybody had any better luck.
> 
>      
> 
>     I also tried pgAdmin 4, Beta 2, which is documented as working for
>     Win 7.  However, the dialog for creating a Server connection does
>     not have support for SSL tunneling, which is required to get to the
>     database.  Is SSL tunneling no longer supported?

Strange thing is, it seems to be getting worse over time (1.22.1 worked
fine on both my Windows 7 box and my work MacBook Pro (El Capitan) when
I first started using it). Today I lost about two hours of work total
from repeated crashes.

You can manually set up a tunnel with PuTTY, then connect to locahost.


-- Stephen




Re: Running pgadmin on Windows 7; SSL tunneling

From
Dave Page
Date:
On Tue, Jun 28, 2016 at 11:33 PM, Chris Benenati <cbenenati@impactnw.org> wrote:
> I tried running pgAdmin 3, both versions 1.18.1 (the latest version
> available for Win 7 according to the notes on the download page) and 1.22.1
> (the latest version).  Both crash on my Windows 7 system when I try to do
> almost anything.  Has anybody had any better luck.

Yeah, unfortunately that code (much of which is in a 3rd party
library) has issues.

> I also tried pgAdmin 4, Beta 2, which is documented as working for Win 7.
> However, the dialog for creating a Server connection does not have support
> for SSL tunneling, which is required to get to the database.  Is SSL
> tunneling no longer supported?

Not in v1.0, though you can of course easily setup tunnels yourself
from the command line, then have pgAdmin connect to them.

We do intend to re-add SSH support in a future release, almost
certainly using the OS provided SSH client, or in the case of Windows,
Putty.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company