How to rotate the EC2 pem file of RDS Postgres database without a downtime?

0

We have RDS postgres database in both Prod and dev environments. We would like to rotate the pem file of underlying EC2 machine but we want to make sure this will not cause downtime to our database. We have a continuous traffic across the world and having a downtime is not possible for us.

Please advise.

Raj M
demandé il y a 8 mois233 vues
3 réponses
0

Hi,

You can utilize AWS Lambda , AWS Systems Manager and AWS Secrets manger to automate the rotation of AWS SSH keys of an EC2 instance. here is an example blog for the solution https://aws.amazon.com/blogs/security/how-to-use-aws-secrets-manager-securely-store-rotate-ssh-key-pairs/

Thanks, Abhishek

profile picture
répondu il y a 8 mois
  • Thanks Abhishek for the response.

    This is a generic solution of rotating the pem file of EC2. I am specifically looking for EC2 behind RDS database as we need to make sure this will not cause production downtime.

0

From your question i thought your are running a Postgres Database on an EC2 instance. If you are using AWS RDS managed service and would like to rotate the database login credentials. You can utilize the Secrets Manger here is the blog for the solution .

https://aws.amazon.com/blogs/security/rotate-amazon-rds-database-credentials-automatically-with-aws-secrets-manager/

profile picture
répondu il y a 8 mois
0

If you are running RDS then there is no underlying EC2 for you to manage. Therefore there is no PEM file to rotate.

profile picture
EXPERT
répondu il y a 8 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions