Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://cloud.google.com/database-migration/docs/postgresql-to-alloydb/promote-migration below:

Promote a migration | Database Migration Service

Stay organized with collections Save and categorize content based on your preferences.

Promotion means that the destination AlloyDB for PostgreSQL instance is disconnected from the source, and is promoted from a replica instance to a primary instance.

For continuous migrations, you can initiate the promotion process after it's time to move reads and writes to the destination.

To promote a migration without loss of information, follow these steps:

1. Go to the Migration jobs page.

2. Click the migration job that represents the migration that you want to promote. The Migration job details page appears.

After the full dump phase has completed and the migration job is in CDC phase, the option for promotion is available.

3. Immediately after transitioning to the CDC phase, depending on the size of the dump, there may be a long replication delay because the AlloyDB for PostgreSQL destination instance catches up on changes that occurred during the dump and load.

   Wait for the replication delay to trend down significantly, ideally on the order of minutes or seconds. The replication delay is available for review on the migration job page.

4. After the replication delay is at a minimum, you can initiate the promotion. To avoid data loss, make sure to:
   1. Stop all writes, running scripts, and client connections to the source database. The downtime period begins here.
   2. Wait until the replication delay is at zero, which means that the migration job has processed all outstanding changes.
   You can promote a migration even if the replication delay isn't at zero. This can reduce the database downtime, but may affect the accuracy of the data in the destination.
5. In the Migration job details page, click Promote.
6. In the Promote migration job? window, click Promote.
7. The migration job stops reading from the source and the substatus is Promote in progress. At this point, you cannot stop or undo the promotion process.
8. The destination instance is promoted to a primary writeable instance. The migration job status is Completed.
9. The application can now be connected to the AlloyDB for PostgreSQL instance and the migration job can be safely deleted.

When you promote migration jobs that have failed or were manually stopped during CDC phase, data on the source and the destination can be inconsistent.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-08-07 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["Promotion of an AlloyDB for PostgreSQL migration job converts the destination instance from a replica to a primary instance, disconnecting it from the source."],["The promotion option becomes available after the full dump phase is completed and the migration is in the CDC phase, but it is ideal to wait until the replication delay is minimal."],["Before promoting, all writes, scripts, and client connections to the source database must be stopped to prevent data loss."],["After the promotion process is initiated, it cannot be stopped or undone, and the destination instance becomes the primary writable instance."],["Promoting a failed or manually stopped migration during the CDC phase can result in data inconsistencies between the source and destination databases."]]],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4