Postgres Tunneling SSH -L In background

Question

I'm trying to open an ssh connection to let one server access a remote postgres database. So I followed the instructions in this postgres help page.

When I run the command:

ssh -L 3333:foo.com:5432 [email protected]

It connects me automatically to the remote server the same way it would with a regular ssh. At that point my connection works fine. The problem I'm facing is when I close the terminal, the connection is lost so I looked on how to run that same command in the background but with no luck. This is what I tried but it doesn't actually work:

nohup ssh -L 3333:foo.com:5432 [email protected] &

How can I run the ssh -L tunneling command in the background?

Thanks in advance.

Note that ssh -L 3333:localhost:5432 [email protected] is the usual way, contrary to ssh -L 3333:foo.com:5432 [email protected] which generally leads to Connection refused. See a more recent version of the help page you linked to at: postgresql.org/docs/9.3/static/ssh-tunnels.html which has been updated to explain this. — Daniel Vérité
– Daniel Vérité, Commented Oct 19, 2013 at 12:28

Maher Manoubi · Accepted Answer · 2013-10-17 18:23:01Z

6

After trying few options of ssh, I actually found the solution. Here it is:

ssh -f -N -L 3333:foo.com:5432 [email protected]

answered Oct 17, 2013 at 18:23

Maher Manoubi

6251 gold badge8 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ThorSummoner Over a year ago

-f Requests ssh to go to background just before command execution.

Collectives™ on Stack Overflow

Postgres Tunneling SSH -L In background

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related