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. 

  • 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..)