Question

A company is migrating a 4 TB on-premises production PostgreSQL database to a managed cloud database service. The application must remain available during the migration, and the business will only tolerate a few minutes of downtime during the final cutover. Which data migration approach best meets these requirements?

Accepted Answer

Take a full backup, restore it to the cloud database, then enable continuous replication (change data capture) to keep it in sync until a brief cutover

Answer

Perform a one-time offline export of the database to a dump file, upload it to cloud storage, and import it into the managed service during a scheduled maintenance window

Answer

Set up a VPN tunnel and point the on-premises application directly at the cloud database to avoid any data copy

Answer

Provision a larger instance in the cloud and rely on the managed service's auto-scaling to pull the data over automatically