Step 1: Check the SSH connectivity with the server, verify username and password.
Step 2: Create the tunnel in your local system by executing the following command (It will prompt for password):
Step 3: Now, open your PostgreSQL client (eg,
pgAdmin 3 or
Postico for OS X or
Terminal) and fill in the connection details as usual. Check the image below.
Note: Yes, you’ll have to use