Major upgrade of Cloud SQL Postgres (GCP)

vitobotta

We are still running on PG 11 with Cloud SQL and I would like to do a first migration to v12, and then newer versions a little per time.

What is the easiest/recommended way to do this with GCP/Cloud SQL? I'd like to minimize downtime or avoid it altogether if possible.

Thanks!

Kassem

You either do it manually by doing the usual steps of setting up new instance and then exporting (after either making app read only if possible or maintenance window) and importing into new instance (doing this on production after validating the entire process on staging) or use this semi-automatic Database Migration Service which is recommended as you don't have to stop using the old database while it is syncing (helpful if your db is big and waiting for manual export/import will be annoying).

https://cloud.google.com/blog/topics/developers-practitioners/upgrade-postgres-pglogical-and-database-migration-service
https://cloud.google.com/database-migration/docs/postgres/configure-source-database

Manual:
https://cloud.google.com/sql/docs/postgres/upgrade-major-db-version

vitobotta

@Kassem said:
You either do it manually by doing the usual steps of setting up new instance and then exporting (after either making app read only if possible or maintenance window) and importing into new instance (doing this on production after validating the entire process on staging) or use this semi-automatic Database Migration Service which is recommended as you don't have to stop using the old database while it is syncing (helpful if your db is big and waiting for manual export/import will be annoying).

https://cloud.google.com/blog/topics/developers-practitioners/upgrade-postgres-pglogical-and-database-migration-service
https://cloud.google.com/database-migration/docs/postgres/configure-source-database

Manual:
https://cloud.google.com/sql/docs/postgres/upgrade-major-db-version

Thanks a lot for your help!