Hi I am trying to connect to Postgres from pgAdmin3 using SSH tunneling. However I am not using standard port 22. How can I do SSH tunneling using a non standard port?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
You could setup the ssh connection and tunnel outside pgAdmin and just let pgAdmin connect to the localport.
If you use 15432 as localport then you can let pgAdmin connect to localhost with port 15432 and you leave the SSH tunnel option in pgAdmin OFF!
In the PGAdmin III connection manager, there is an option for the port you'd like to use under SSH tunnel. It looks like a port option was added for SSH tunneling recently. Are you using the newest version?
Here is a link to the PGAdmin III connection manager screen that shows the SSH Tunnel tab.
Update: The latest binary build with this fix is not posted to the website yet. I suggest building it yourself from the development site or else contacting the maintainer to inquire about when the newest binary release will be ready.