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ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ