Register Postgres DB via SSH Tunnel

Is there a way to make DPA use a ssh tunnel to connect to postgres DBs I have in aws? Any postgres tool I've ever used (pgadmin, dbbeaver, datagrip) has the option to connect to the DB this way.

Parents

0 mcitmedina 1 month ago

basically you have to do it via a 3rd party tool for now. Here's how i did it in powershell:

Kick off SSH forwarding via powershell
ssh -i .\abc11111.pem -fN -L 5555:rdsinstancedns1.rds.amazonaws.com:5432 ec2-user@bastionhostDNS1.amazonaws.com
ssh -i .\abc11111.pem -fN -L 5556:rdsinstancedns2.rds.amazonaws.com:5432 ec2-user@bastionhostDNS2.amazonaws.com
ssh -i .\abc11111.pem -fN -L 5557:rdsinstancedns3.rds.amazonaws.com:5432 ec2-user@bastionhostDNS3.amazonaws.com

Validate that it is listening on 127.0.0.1 port XXXX (5555,5556,5557 above)::
netstat -anovb | findstr LISTENING

connect DPA instance: to 127.0.0.1 port XXXX (IE: rdsinstance 1 is 5555, 2 is 5556, 3 is 5557, etc..)
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Reply

0 mcitmedina 1 month ago

basically you have to do it via a 3rd party tool for now. Here's how i did it in powershell:

Kick off SSH forwarding via powershell
ssh -i .\abc11111.pem -fN -L 5555:rdsinstancedns1.rds.amazonaws.com:5432 ec2-user@bastionhostDNS1.amazonaws.com
ssh -i .\abc11111.pem -fN -L 5556:rdsinstancedns2.rds.amazonaws.com:5432 ec2-user@bastionhostDNS2.amazonaws.com
ssh -i .\abc11111.pem -fN -L 5557:rdsinstancedns3.rds.amazonaws.com:5432 ec2-user@bastionhostDNS3.amazonaws.com

Validate that it is listening on 127.0.0.1 port XXXX (5555,5556,5557 above)::
netstat -anovb | findstr LISTENING

connect DPA instance: to 127.0.0.1 port XXXX (IE: rdsinstance 1 is 5555, 2 is 5556, 3 is 5557, etc..)
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Children

No Data