Home icon

AWS DMS homogenous migration from PostgreSQL to Amazon Aurora PostgreSQL

Database Blog



This article provides a detailed guide on how to perform a homogeneous database migration from PostgreSQL to Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL using AWS Database Migration Service (AWS DMS).

Specifically, the article covers:

  • Solution overview and prerequisites
  • Configuring source and target database permissions
  • Creating an IAM policy and role
  • Creating data providers and instance profile
  • Creating a migration project and data migration task
  • Validating the migration and testing CDC scenarios
  • Limitations and troubleshooting steps
  • Viewing log files and cleaning up resources


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

Aug 5
2024
Migrate an on-premises MySQL database to Amazon Aurora MySQL over a private network using AWS DMS homogeneous data migration and Network Load Balancer
Jun 23
2025
Migrate a self-managed MySQL database to Amazon Aurora MySQL using AWS DMS homogeneous data migrations
May 12
2026
Migrating Amazon RDS for PostgreSQL to Amazon Aurora using seeded logical replication
Jun 10
2026
How to migrate from Oracle to Amazon Aurora PostgreSQL using AWS CloudFormation (Part 1)

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.