Please add support for SSH tunneling.

[mxxcon]

Please add support for ssh tunneling in situations where database is not accessible directly from the internet.

[Paxa]

I think it's gonna be useful, will add it.

For now you may open ssh tunnel manually and connect to local port of a tunnel

[smoothdvd]

working on it

[tobymao]

for anyone who's gotten this to work, could you provide how you did it?

i've tried various solutions like ssh and sshuttle without success

my server only allows localhost connection and have connected to it in the past with apps like postico which do support ssh tunneling

[Paxa]

I've got somehow working code on local, but not proper yet, I will try push something soon

[Paxa]

To make ssh tunnel you may run locally

ssh [email protected] -L 15432:127.0.0.1:5432 -N
                          ^ local port     ^ remote port

and connect to your localhost on port 15432, but it won't work with unix socket connection

[tobymao]

thank you, i independently also just figured it out and got it working using a command similar to yours

[zrbecker]

For anyone doing this with a AWS bastion to an RDS instance you want to do

ssh -N -L 15432:endpoint.rds.amazonaws.com:5432 username@public-ip-ec2-bastion