Best practice of keeping RDS private and managing it

I moved my RDS to a private subnet. But now I cannot connect to the DB using pgadmin locally. What is the best practice to manage a RDS?

主题

标签

语言

English

已提问 2 个月前341 查看次数

2 回答

已接受的回答

Hello.

To connect to RDS using pgadmin etc. from a local terminal, I think the configuration of the following AWS blog will be helpful.
This configuration uses EC2 managed by Systems Manager as a stepping stone and performs port forwarding via Session Manager.
https://aws.amazon.com/jp/blogs/mt/use-port-forwarding-in-aws-systems-manager-session-manager-to-connect-to-remote-hosts/

专家

已回答 2 个月前

专家

已审核 2 个月前

Jehan
2 个月前
Hello does this work for an existing RDS? I couldn't find a way so that I can attach an EC2 to the RDS.
Riku_Kobayashi 专家
2 个月前
Yes, you can use it with your existing RDS. For RDS communication from EC2, configure the RDS security group inbound rules to allow the database listening port just like a normal database. The EC2 bastion must be registered as a managed instance in Systems Manager.

Hi,

It is not exactly the same, but if you are using an Aurora DB cluster, you could use the Aurora Query editor even when deployed on a private subnet.

专家

已回答 2 个月前

相关内容