Search code examples
ssh-tunnelpostgresql-9.6pgadmin-4

Connection remote Postgres server with ssh tunneling using pgAdmin4

I am using pgAdmin4 version 3.1 on macOS. Today I tried to connect my remote Postgres server with ssh tunneling. When my remote server ssh port is the default (22) then there is no any problem. pgAdmin can connect to the server by creating a ssh tunnel. But if you assign different port like me pgAdmin could not create a ssh tunnel. I don't know this problem exist on Windows or not. But on macOS pgAdmin4 could not create ssh tunnel if the remote server port is not 22.

Solution

  • Try downloading pgAdmin4 v3.2, I have seen some fixes around SSH tunneling.

    Ref: https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_3_2.html