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 Respostas
1
Resposta aceita

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
ESPECIALISTA
respondido há 2 meses
profile picture
ESPECIALISTA
avaliado há 2 meses
  • 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
ESPECIALISTA
respondido há 2 meses

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas