Answer-first summary for fast verification
Answer: Use Database Migration Service to migrate your database.
To migrate an on-premises PostgreSQL database to Compute Engine with minimal downtime, the best approach is to use the Database Migration Service (option C). This service is designed to minimize downtime by continuously replicating data from the source to the target database until you are ready to switch over. Option A involves manual backup and restore processes, which can lead to significant downtime. Option B suggests using Cloud SQL, which is not the same as migrating to Compute Engine. Option D involves setting up a hot standby and using PgBouncer, which is more complex and may not guarantee minimal downtime compared to using the Database Migration Service.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you migrate an on-premises PostgreSQL database to Compute Engine with minimal downtime?
A
Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.
B
Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
C
Use Database Migration Service to migrate your database.
D
Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
No comments yet.