Migrate Amazon Aurora PostgreSQL across major versions with active Debezium CDC connectors using native logical replication

Standard Aurora PostgreSQL major-version upgrade paths (in-place upgrade, blue/green deployment) break active Debezium CDC replication slots, forcing hours-long re-snapshots for downstream consumers. This walkthrough shows an alternative using native PostgreSQL logical replication to bridge a source cluster (PostgreSQL 14) and a target cluster (PostgreSQL 17), synchronizing data, then executing a brief cutover that disables the subscription, syncs sequences, creates a new Debezium slot on the target, and redirects the connector with snapshot.mode=never. In testing, the database-side cutover took about 2.21 seconds with zero duplicate or missed events. The post also details parameter group settings, network requirements, five failure scenarios (failover, connector stalls, oversized Kafka messages, DDL changes, long-running transactions), rollback procedures, post-migration monitoring signals, and how to scale the pattern via CDK/Step Functions automation.

Source: https://aws.amazon.com/blogs/database/migrate-amazon-aurora-postgresql-across-major-versions-with-active-debezium-cdc-connectors-using-native-logical-replication. 8 Sync News only summarizes and links out; content copyright belongs to the authors and original sources.