IssueTracker

This is now supported on Cloud SQL: https://cloud.google.com/sql/docs/postgres/extensions#data-type-extensions

Hi @paul@mymove.co,

Thanks for the update.

To figure out the root cause of the issue I require Project details. I have created a private ticket for which you should have received a notification. Please provide requested information there. Don't put any personal information, including project identifiers in this public ticket.

Thank You

Thanks for following up. Requested information shared.

Hi @paul@mymove.co,

Thanks for sharing the details. This has been forwarded to the Team so that they may evaluate it. Note that there are no ETAs of implementation. All communication regarding this is to be done here.

Hello,

It is a known issue by the product team and the product team has confirmed the issue has been fixed recently. Can you confirm for me, are you still facing the issue?

We now get the following error:

pre-upgrade check failed: errors:{type:INVALID_EXTENSION_VERSION detail:"extension \"postgis\" needs to be upgraded to \"3.1.7\" before major version upgrade for database \"postgres\""}

So this means this will be resolved when the upcoming automatic upgrade to Postgres 13.8 is performed, because then PostGIS 3.1.7 is available (it isn't available in Postgres 13.7).

We get the same error when attempting to upgrade from postgres 11 to 12. postgis 3.1.4 is installed on our postgres 11 instance.

pre-upgrade check failed: errors:{type:INVALID_EXTENSION_VERSION detail:"extension \"postgis\" needs to be upgraded to \"3.1.7\" before major version upgrade for database \"test-db\""}

It would appear to be related to the upgrades that were announced on October 19 and then later postponed. https://cloud.google.com/sql/docs/postgres/release-notes#October_19_2022

Bump

Hello,

Team updated that the issue is fixed. Can you please check and confirm?

No, still the same error when updating from 13.7 to 14:

2023-02-07 17:10:30.030 UTC [125]: [1-1] db=cloudsqladmin,user=cloudsqladmin ERROR: extension "google_insights" has no update path from version "1.3" to version "1.2"