QuestionQ91

VerifiedMigrate data solutions

You are migrating a 10 TB on-premises PostgreSQL database to Cloud SQL for PostgreSQL by using Database Migration Service. Schema changes will occur in the source database during the migration. You need to ensure that all schema changes are replicated while minimizing disruption to the ongoing migration.

What should you do?

Explanation

During a continuous PostgreSQL migration, Database Migration Service automatically replicates DML changes, not standard DDL changes. Running schema changes on the source through pglogical.replicate_ddl_command applies them to both the source and destination at a consistent point, minimizing disruption to the migration.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!