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.
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..)
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.