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
已提問 8 個月前檢視次數 233 次
3 個答案
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
已回答 8 個月前
  • 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
已回答 8 個月前
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
專家
已回答 8 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南