Home icon

Migrate self-managed PostgreSQL to Amazon RDS using the RDS console

Database Blog

This article demonstrates how to migrate self-managed PostgreSQL databases from Amazon EC2 to Amazon RDS using the RDS console's built-in AWS DMS homogeneous migration capability.

  • RDS console auto-migration uses AWS DMS homogeneous data migration with PostgreSQL native tools for faster, more precise schema and data mapping
  • Three replication modes available: Full load, CDC only, or Full load + CDC for minimal downtime production migrations
  • Source requires PostgreSQL 10.4+, logical replication enabled, and DMS user with replication privileges
  • Target requires rds.logical_replication parameter enabled and rds_superuser role with appropriate permissions
  • Homogeneous migrations don't support tablespaces, roles, extensions, or DDL changes during CDC replication
  • Post-migration includes ANALYZE, REINDEX, and security hardening steps like disabling DMS user and rotating credentials

This approach simplifies PostgreSQL-to-PostgreSQL migrations by combining DMS reliability with minimal setup effort through the RDS console interface.

Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Jul 20
2026
Migrate from AIX or Windows Db2 to Amazon RDS for Db2
Aug 7
2026
Migrating and Modernizing Oracle Databases to PostgreSQL on AWS – Part 1: Discovery
Aug 7
2026
Migrating and Modernizing Oracle Databases to PostgreSQL on AWS – Part 2: Assessment
Jan 18
2024
Migrate from self-managed Db2 to Amazon RDS for Db2 using AWS DMS

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.