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