We migrated from AWS to GCP with minimal downtime

Description and use

Migrated PostgreSQL with PostgresML from AWS to GCP with minimal downtime.

Problem

The team needed to move their PostgreSQL-based ML workloads from AWS to GCP while keeping downtime to a minimum.

Outcome

The migration was completed with minimal downtime, enabling the organization to benefit from GCP’s infrastructure while maintaining continuous ML operations.

Workflow

• 1. Set up a GCP Cloud SQL instance with PostgresML extension installed.
• 2. Export PostgreSQL data from AWS using pg_dump or logical replication.
• 3. Import data into GCP Cloud SQL via pg_restore or streaming replication.
• 4. Update application connection strings to point to the new GCP instance.
• 5. Perform a final sync to capture any changes made during migration.
• 6. Switch traffic to the GCP instance and decommission AWS resources.

Evidence

We migrated from AWS to GCP with minimal downtime

Source

We set up a GCP Cloud SQL instance with PostgresML extension installed

Source