We are attempting to connect to our Postgres 9.6 database in AWS using SSH, which we do with our current tool Postgres Maestro. Below are the Connection Properties we are using:
Connection Settings:
- Hostname/Port: set to private ip address / port relative to SSH host
- Database, Username, Password - valid on the host
SSH Authentication:
- Enable SSH: True
- SSH host: public ip address of a host that has access to our postgresql database
- Username: set to valid username on SSH host
- Certificate Authorization, Enable: True
- Certificate: points to file of PEM format containing private key, generated with Putty Key Generator
- Passphrase: set to the passphrase for the private key
Testing the connection from SSH Authentication Tab results in a “Connection has failed. The connection attempt failed.” message. We have confirmed from the SSH hosts auth.log that an attempt to connect using the key was successful and see the connection close down when we exit the Toad Edge application
We have been able to connect to our database through port forwarding by opening a tunnel in Putty and then using localhost as the host string, but would prefer to not have to do this first.