Connect to Postgres via ssh tunnel

Question

I have an access to database only from remote server. That means I have ssh access to remote_server And I have psql access from remote_server to database_server I don't have ssh access from remote_server to database_server (It's Amazon RDS)

How can I connect to my database from localhost? I know that I can establish ssh tunnel from localhost to remote_server like this: ssh -fN -L 9997:localhost:9996 ubuntu@remote_server

So after this I want to connect remote_server:9996 port with database_server:5432 port. How can I establish this?

Answer 1

You just need to set the remote port as database_server:5432.

This should do the trick:

ssh -L 9997:database_server:5432 ubuntu@remote_server

Requests to localhost:9997 will be forwarded to database_server:5432 through the tunnel on remote_server