Postgres 9.6 EOL

[Aled]

Hi,

I have just started a new role, and have discovered that we have some Cloud SQL Postgres databases at version 9.6. We're planning an upgrade, but I would like to know how to find out when GCP is planning to pull the plug/force upgrade 9.6 dbs.

I've found this press release dated 2021-06-09: https://cloud.google.com/blog/products/databases/postgresql-9-6-cloud-sql-version-support-past-end-o...

The final update for PostgreSQL 9.6 will come in November 2021, and Cloud SQL will make it available shortly after, and support it as is. While we won’t be able to provide patches, we will provide platform-level support.

I've also found this https://cloud.google.com/sql/docs/postgres/db-versions

When Cloud SQL intends to end support for a specific major version, we will send a deprecation notice alerting customers a minimum of 12 months ahead.

I can't find a deprecation notice, but that may not mean that one doesn't exist :D.

Cheers!

[comaro · Accepted solution]

Hi, Aled,

The final release for PostgreSQL 9.6 was on November 11th, 2021. But as per this document Cloud SQL will continue to support the final release of PostgreSQL 9.6 for at least one year after the general availability of Cloud SQL for PostgreSQL in-place major version upgrade, i.e., around November 2022.

When Cloud SQL intends to end support for a specific major version, we will send a deprecation notice alerting customers a minimum of 12 months ahead. I would like to mention that you should opt in for product related notifications and the notifications will be sent to the IAM principal with the owner role on the project.

We cannot delay the mandatory upgrade as the final release for PostgreSQL 9.6 was on November 11th, 2021 but in the meantime you can upgrade underlying code using those DBs before they are upgraded to newer PostgreSQL versions.

Cloud SQL will provide tools to minimize upgrade disruption, as needed. The Google Cloud team will automatically upgrade (to Postgres 10) any instance that has not moved to the new major version at the end of the 12-month period.

Furthermore I would like to communicate to you that once PostgreSQL 9.6 is deprecated, you won't be able to create new Cloud SQL instances with PostgreSQL 9.6 version.

When will PostgreSQL 9.6 be deprecated for Cloud SQL?

There is no ETA.

I hope the above furnished information answers your query.