Migrating Postgres from AWS to GCP

[pratikd]

We are making a transition from AWS to GCP. We have a Postgres DB (Aurora) which has approximate 10 million rows and each row is encrypted by AWS KMS. Now that we are migrating to GCP, we will have to migrate entire DB to Alloy DB (Postgres). For every row in the AWS DB, migration will involve following steps:
1. Decrypt via AWS KMS
2. Encrypt the text with GCP Cloud Key Management
3. Insert the row into GCP Alloy DB

Please suggest an approach to do this with minimal downtime (10 to 15 mins) This is what I have been thinking: Use a CDC tool like Debezium. and write a sink connector which will perform the above steps. We will initially do a full load and then let both the databases come in sync.Is there any better approach than this which would be more efficient?

[robertcarlos]

Hi @pratikd,

Welcome to Google Cloud Community!

I would suggest using Database Migration Service for PostgreSQL as this supports migration from Amazon RDS to Google Cloud SQL for PostgreSQL (this is also available for MySQL and MS SQL Server).

Below are the database migration: concepts and principles divided into 2 parts:

• Part 1 
• Part 2 

You could also check the following documentations that you can check and follow as references:

• Migrating AWS RDS to Cloud SQL using GCP DMS 
• Migrating from AWS RDS to GCP Cloud SQL 
• AWS Aurora Postgres to GCP Cloud SQL Postgres using External Replica With SSL 

If the aforementioned steps didn't work, you may file a feature request so that our engineers could take a look at this. We don't have a specific ETA but you can keep track of its progress once the ticket has been created.

Hope this helps.