Does anyone know how to connect to the AWS RDS Pos...
# helpt
T Indie
05/14/2022, 1:48 PMDoes anyone know how to connect to the AWS RDS PostgreSQL database using PgAdmin, I can access the "Query Editor" as described here via the secrertARN provided by SST, however to connect using PgAdmin a "master password" is needed, any idea how to find it? or if anyone knows a better way to connect to pgAdmin? Thanks in advance
f
Frank
05/14/2022, 1:50 PM
Hey @T Indie, if u go into u AWS secret manager console, find the secret, can u fine the password there?
t
T Indie
05/14/2022, 2:00 PMYES, thanks 🙂 however it can not connect because probably it's not accessible outside the VPC. I will check the guide https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.Scenarios.html and try to figure a way to connect to the database from my local machine.
r
Robert Chandler
05/15/2022, 3:36 PMWe can connect to our private RDS from a local machine by having a small gateway EC2 instance that is inside the same VPC/subnets as the db but also accessible publicly through ssh. We port forward the (in our case) postgres ports and can interact with the db locally
t
T Indie
05/15/2022, 4:35 PMSounds great, that's exactly what I would like to do. Thanks for sharing @Robert Chandler