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개 답변
1
수락된 답변

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
전문가
답변함 2달 전
profile picture
전문가
검토됨 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.

  • 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
전문가
답변함 2달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠