Migrating from AWS RDS Postgres to Cloud SQL Postgres

[Shrinivasa rao]

Hi,

We are planning to migrate a postgres instance in AWS RDS to GCP Cloud SQL.

For now, we are not planning to use GCP database migration service.

Just wanted to know if we just take dump from AWS RDS and restore it in GCP, will it work? Do we need to create users before importing the database in GCP.

[David (Cloud Platform Support)]

Hello,

You would need to follow  these instructions when exporting the data to make sure the dump will be importable into Cloud SQL. You would also need to follow the importing guidelines as well to make sure you encounter no issues at the moment of importing the dump.