QuestionQ37

VerifiedMigrate data solutions

You are migrating a 2 TB on-premises PostgreSQL cluster to Compute Engine. You want to configure the new environment on an Ubuntu virtual machine instance in Google Cloud and seed data to a new instance. You need to plan the database migration to ensure minimal downtime. What should you do?

Explanation

A PostgreSQL physical base backup can be taken while the source remains online. Restoring that backup at the destination and applying archived WAL lets the destination continuously recover changes made after the backup. Stopping source writes only for the final WAL transfer and waiting for replay to catch up limits the outage to the cutover period. Logical exports do not provide the physical data files needed for WAL recovery.

Learn more

Community Discussion

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