AWS Database Blog
Author: Lavanya Salokye
Migrate self-managed PostgreSQL to Amazon RDS using the RDS console
Migrate a self-managed PostgreSQL database on Amazon EC2 to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition using the auto-migration capability in the Amazon RDS console, powered by AWS Database Migration Service (AWS DMS) homogeneous data migrations.
Automate Amazon RDS credential rotation with AWS Secrets Manager for primary instances with read replicas
When using Secrets Manager to manage your master user passwords, you cannot create new read replicas for your database instance. This applies to all DB engines except Amazon RDS for SQL Server, potentially impacting your organization’s ability to efficiently scale its read operations while maintaining secure credential practices. In this post, we present a solution that automates the process of rotating passwords for a primary instance with read replicas while maintaining secure credential management practices. This approach allows you to take advantage of the benefits of both read scaling and automated credential rotation.