Web lists-archives.com

Re: PgAdmin with SSH tunnel

On 2018-06-10, <tomas@xxxxxxxxxx> <tomas@xxxxxxxxxx> wrote:
> On Sat, Jun 09, 2018 at 03:23:06PM +0300, Georgi Naplatanov wrote:
>> Hi,
>> I'm using Debian Stretch and I'm trying to connect to PostgreSQL server
>> (Debian 9) with PgAdmin (Debian 9) through SSH tunnel.
>> PgAdmin has built-in SSH support but when I try to connect to remote
>> PostgreSQL server I get this error in PgAdmin:
>> Error: SSH error: Error when starting up SSH session with error code -8
>> [Unable to exchange encryption keys]
>> I use key pair for OpenSSH authentication.
> You could try to ssh into it with -v (or even -vvv) to increase the
> client's verbosity (or perhaps there's a corresponding option in
> PgAdmin's client). That might give you more insight into what's going
> on.

I read the following response to a similar conundrum (for what it's worth):

 If you require access to a Postgres 9.5 database, you can manually create the
 SSH tunnel, and then connect using pgAdmin3 by setting the host to localhost.
 On Linux or Mac, you can use the following: ssh -L 5432:<pg-host>:5432
 <jump-host-ip-or-dns>. It doesn't seem likely that pgAdmin3 will receive any
 updates with the direction pgAdmin4 is heading.