Re: PgAdmin with SSH tunnel
- Date: Sun, 10 Jun 2018 07:54:52 +0000 (UTC)
- From: Curt <curty@xxxxxxx>
- Subject: 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:
>> 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
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.