On 2018-06-10, <to...@tuxteam.de> <to...@tuxteam.de> 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.
