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 Respuestas
1
Respuesta aceptada

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
EXPERTO
respondido hace 2 meses
profile picture
EXPERTO
revisado hace 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
EXPERTO
respondido hace 2 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas