We migrated from AWS to GCP with minimal downtime

Description and use

Migrated PostgreSQL from AWS to GCP with minimal downtime.

Problem

The team needed to move their PostgreSQL database from AWS to GCP while minimizing downtime.

Outcome

The migration completed with less than 5 minutes of downtime, maintaining data integrity and application availability.

Workflow

• 1. Export the AWS RDS database to a logical dump using pg_dump. 2. Transfer the dump file to a Google Cloud Storage bucket. 3. Import the dump into a new Cloud SQL instance using Cloud SQL import. 4. Update application connection strings to point to the new instance. 5. Verify data integrity and application functionality. 6. Switch DNS or load balancer to route traffic to the new instance. 7. Decommission the old AWS RDS instance.

Evidence

We migrated from AWS to GCP with minimal downtime

Source