Re: PgAdmin with SSH tunnel
On 2018-06-10, <tomas@tuxteam.de> <tomas@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.
Reply to: