How to upgrade GCP Postgresql from old version to new version by using Database Migration DMS in GCP

Topic: How to upgrade GCP Postgresql from old version to the new version by using Database Migration DMS in GCP.


Here’s a step-by-step guide to upgrading GCP PostgreSQL from an old version to a new version by using Database Migration Service (DMS) in GCP:
1.       Create a service account in the Google Cloud Console with the necessary permissions to access your GCP project, PostgreSQL instance, and DMS. You can follow the instructions provided in the official documentation.
2.       Install the Google Cloud SDK on your local machine. You can download it from the official website.
3.       Authenticate your Google Cloud SDK by running the following command in your terminal:
4.  gcloud auth login
 
5.       Set your project ID by running the following command in your terminal:
6.  gcloud config set project <project-id>
 
7.       Create a migration job by running the following command in your terminal:
8.  gcloud dms create-migration <migration-name> --source_database_host=<source-host> --source_database_port=<source-port> --destination_database_host=<destination-host> --destination_database_port=<destination-port> --reverse_ssh_tunnel=<True/False>
 
Replace <migration-name> with a name for your migration job, <source-host> and <source-port> with the hostname and port number of your source PostgreSQL instance, and <destination-host> and <destination-port> with the hostname and port number of your destination PostgreSQL instance. Set --reverse_ssh_tunnel to True if you need to use a reverse SSH tunnel for connectivity.
 
9.       Start the migration job by running the following command in your terminal:
gcloud dms start-migration <migration-name>
 
10.    Monitor the migration status by running the following command in your terminal:
gcloud dms describe-migration <migration-name>
 
11.    Verify the migration by checking that all data has been migrated successfully to the new PostgreSQL instance.
That’s it! You should now have upgraded your GCP PostgreSQL instance from an old version to a new version using DMS.
I hope this helps! Let me know if you have any questions.

Video Demo: How to upgrade GCP Postgresql from old version to new version by using Database Migration DMS in GCP

4 comments:

  1. Перевагою RX.ua є оптимальне співвідношення ціна-якість. Всі продукти https://rx.ua/ , представлені на платформі, мають високу якість і сертифіковані. Також слід зауважити, що онлайн аптека має вигідну програму лояльності, за рахунок якої клієнти отримують додаткові знижки та бонуси при першій реєстрації та замовленні.

    ReplyDelete
  2. Upgrading GCP PostgreSQL from an older version to a newer version using the Database Migration Service (DMS) in GCP is an efficient and secure way to upgrade your database. Pay attention to this function from depositphots.com technology for enlarging images without loss of quality expands the possibilities in the field of creativity and visual processing. This innovative method allows you to increase the size of images while maintaining high clarity, detail and color saturation.

    ReplyDelete
  3. Thanks for sharing this detailed guide. Upgrading GCP PostgreSQL using Database Migration DMS seems straightforward with your step-by-step instructions. Appreciate the clear breakdown and Invisible Text tips provided. This will definitely be helpful for anyone looking to perform this upgrade.

    ReplyDelete