Securely Connect to a Remote PostgreSQL Database with SSH Tunneling

Securely Connect to a Remote PostgreSQL Database with SSH Tunneling

Exposing your database port directly to the internet is like leaving your house unlocked with a “welcome” sign on the door. A safer approach is to use an SSH tunnel (a secur…


This content originally appeared on DEV Community and was authored by Maxiviper117

Securely Connect to a Remote PostgreSQL Database with SSH Tunneling

Exposing your database port directly to the internet is like leaving your house unlocked with a “welcome” sign on the door. A safer approach is to use an SSH tunnel (a secure pipe between your local machine and the remote server). This way PostgreSQL can stay bound to localhost on the server, while you still connect from your laptop.

1. Create an SSH key pair

If you don’t already have an SSH key, generate one locally:

ssh-keygen -t ed25519 -C "your_email@example.com"
  • Private key: ~/.ssh/id_ed25519
  • Public key: ~/.ssh/id_ed25519.pub

Keep the private key safe and never share it. The public key is what you’ll add to the server.

2. Copy your public key to the server

Replace user@remote-server.com with your real username and server address:

ssh-copy-id -i ~/.ssh/id_ed25519.pub user@remote-server.com

If ssh-copy-id isn’t available, you can manually paste the contents of the .pub file into the server’s ~/.ssh/authorized_keys.

3. Add a convenient SSH config entry

Save yourself some typing by creating an entry in ~/.ssh/config:

Host my-server
    HostName remote-server.com
    User user
    IdentityFile ~/.ssh/id_ed25519
    IdentitiesOnly yes

Now you can connect with:

ssh my-server

4. Open the SSH tunnel

Assume PostgreSQL is running on the server at localhost:5432. We’ll forward that to port 5555 on your machine:

ssh -L 5555:localhost:5432 my-server
  • 5555: local port on your computer
  • localhost:5432: PostgreSQL port on the server
  • my-server: alias from your SSH config

Keep this terminal open while the tunnel is active.

Run in the background:

ssh -fN -L 5555:localhost:5432 my-server
  • -f = fork to background
  • -N = don’t execute a remote command, just tunnel

5. Connect with pgAdmin (or any client)

In pgAdmin, DBeaver, or psql, use:

  • Host: localhost
  • Port: 5555
  • User: your database user (e.g. postgres)
  • Password: your database password
  • Database name: the actual DB name

The client talks to localhost:5555, and the SSH tunnel securely forwards everything to PostgreSQL on the server.

6. Closing the tunnel

  • Foreground tunnel: press Ctrl+C.
  • Background tunnel: find and kill it: 
  ps aux | grep 'ssh -L'
  kill <pid>

To Sum Up

With this setup:

  • Your database port remains hidden from the outside world.
  • All traffic is encrypted via SSH.
  • You can connect safely using your favorite GUI tool or CLI.

This pattern works for PostgreSQL, MySQL, Redis, or any other service that you’d rather not expose directly.


This content originally appeared on DEV Community and was authored by Maxiviper117


Print Share Comment Cite Upload Translate Updates
APA

Maxiviper117 | Sciencx (2025-10-01T18:11:18+00:00) Securely Connect to a Remote PostgreSQL Database with SSH Tunneling. Retrieved from https://www.scien.cx/2025/10/01/securely-connect-to-a-remote-postgresql-database-with-ssh-tunneling/

MLA
" » Securely Connect to a Remote PostgreSQL Database with SSH Tunneling." Maxiviper117 | Sciencx - Wednesday October 1, 2025, https://www.scien.cx/2025/10/01/securely-connect-to-a-remote-postgresql-database-with-ssh-tunneling/
HARVARD
Maxiviper117 | Sciencx Wednesday October 1, 2025 » Securely Connect to a Remote PostgreSQL Database with SSH Tunneling., viewed ,<https://www.scien.cx/2025/10/01/securely-connect-to-a-remote-postgresql-database-with-ssh-tunneling/>
VANCOUVER
Maxiviper117 | Sciencx - » Securely Connect to a Remote PostgreSQL Database with SSH Tunneling. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2025/10/01/securely-connect-to-a-remote-postgresql-database-with-ssh-tunneling/
CHICAGO
" » Securely Connect to a Remote PostgreSQL Database with SSH Tunneling." Maxiviper117 | Sciencx - Accessed . https://www.scien.cx/2025/10/01/securely-connect-to-a-remote-postgresql-database-with-ssh-tunneling/
IEEE
" » Securely Connect to a Remote PostgreSQL Database with SSH Tunneling." Maxiviper117 | Sciencx [Online]. Available: https://www.scien.cx/2025/10/01/securely-connect-to-a-remote-postgresql-database-with-ssh-tunneling/. [Accessed: ]
rf:citation
» Securely Connect to a Remote PostgreSQL Database with SSH Tunneling | Maxiviper117 | Sciencx | https://www.scien.cx/2025/10/01/securely-connect-to-a-remote-postgresql-database-with-ssh-tunneling/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts