What does it mean when pgadmin 4 returns "No password or public key available!"?

Question

I set up a remote database connection using an ssh tunnel with an identity file and password. I added localhost to connection hostname and added username and password for database access. When I click on save and connect now the program returns:

No password or public key available!

What is pgadmin really trying to tell me here? I added all passwords and the identity file is selected from the local hard drive. So it is available. Does it mean the key file is not working??

Answer 1

Private ssh keys come in two formats. PPK and PEM. If you work with e.g. AWS EC2 instances you will get a .pem file. If you work with putty/cygwin you will get a .ppk file.

The

No password or public key available

error in pgAdmin means that you are trying to establish a ssh connection with a wrong key format.

With tools like Puttygen you can convert pem to ppk. There are multiple tutorials online for converting keys.