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??
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.