Managed Upgrade for Postgres Instances
With Postgres 9.6 EOL on the horizon (November 11, 2021), we need to start thinking about our upgrade process to get on the latest version of Postgres. The main reason we use Cloud SQL is that we do not have expertise in DB administration, so we are worried about this upgrade process.
Unfortunately, Cloud SQL does not support managed upgrades of instance. It would be great if Cloud SQL could manage this for us by leveraging pg_upgrade (a la RDS).
The Cloud SQL team is investigating supporting major version upgrades for MySQL and PostgreSQL.
Marek Suscak commented
It'd be great to support this feature across the board (incl. MySQL in-place upgrades).