Postgres Pro
Downloads
Home   >   mailing lists

Re: pgAdmin4 ssh tunnel configuration - Mailing list pgadmin-support

From Akshay Joshi
Subject Re: pgAdmin4 ssh tunnel configuration
Date
Msg-id CANxoLDdrn1mAvtdhYD4rWsVtX-5Y+7kL0pZ4LCgxMpQxwP6eJA@mail.gmail.com
Whole thread Raw
In response to pgAdmin4 ssh tunnel configuration  (Richard Greenwood <richard.greenwood@gmail.com>)
Responses Re: pgAdmin4 ssh tunnel configuration  (Cory Nemelka <cnemelka@gmail.com>)
List pgadmin-support
Tree view
Hi Richard 

On Sun, Jul 1, 2018 at 9:13 PM, Richard Greenwood <richard.greenwood@gmail.com> wrote:
I can't get the ssh tunnel configuration that I use with pgAdmin3 to work with 4. After I enter the
parameters and click "Save" I immediately get a dialog box that says:

Connection to the SSH Tunnel for host 'my-postgres-server' has been lost. Reconnect to the database server.

I'm using identity file authentication. In pgAdmin3 it wants both the private and public key files. In pgAdmin4 only the private file is specified. Otherwise everything is the same. 

The error is instantaneous and the server is 1000 miles away, so it's not even waiting for a tunnel to get opened or a database connection to be attempted.

  • You are creating the ssh tunnel using same machine or there is some another machine in between? 
  • If it's another machine, have you append the public key to the "authorized_keys" file?
  • Can you please provide logs and screenshot of the server dialog with ssh tunnel settings (if possible). To enable logging, ref: https://www.pgadmin.org/faq/#8  

Any suggestions?
Thanks
--
Richard W. Greenwood, PLS
www.greenwoodmap.com



--
Akshay Joshi
Sr. Software Architect


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

pgadmin-support by date:

Previous
From: Khushboo Vashi
Date:
Subject: Re: Prevent password change
Next
From: Henrik Uggla
Date:
Subject: SV: Prevent password change