Best practice of keeping RDS private and managing it

0

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?

2 Answers
1
Accepted Answer

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/

profile picture
EXPERT
answered 7 months ago
profile picture
EXPERT
reviewed 7 months ago
  • Hello does this work for an existing RDS? I couldn't find a way so that I can attach an EC2 to the RDS.

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

0

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.

profile picture
EXPERT
answered 7 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions