Best practices to handle AWS DMS tasks during PostgreSQL upgrades

This article provides comprehensive guidance on handling AWS Database Migration Service (DMS) tasks during PostgreSQL database upgrades, covering both minor and major version upgrades for source and target databases.

• Minor version upgrades typically require stopping DMS tasks before the upgrade and resuming afterward
• Major version upgrades are more complex and require careful handling of replication slots
• For source database major upgrades, key steps include:
  • Stop application connections
  • Verify low task latency
  • Stop DMS tasks
  • Remove existing replication slots
  • Complete the upgrade
  • Create a new CDC-only task or manually create a replication slot
• Target database upgrades require checking replication instance compatibility

The article emphasizes the importance of careful planning and execution during PostgreSQL upgrades to minimize disruption to database migration processes.