Unable to upgrade Postgres 15 to Postgres 16 (Cloud SQL)

[jaebum]

The upgrade simply fails with the error "Failed to upgrade ..." without any errors.

Is there a way to investigate this?

[DamianS]

Hello @jaebum  ,Welcome on Google Cloud Community.

Highly recommend to check logs from Logs Explorer with "Stream logs" and filters enabled. It will allows you to track changes near in live view. 

logs query:

resource.type="cloudsql_database"
resource.labels.database_id="webaap-wordpress-load:test"

 logs

--
cheers,
DamianS
LinkedIn medium.com Cloudskillsboost

[jaebum]

Thanks - only relevant error I could find around the upgrade time was:

user=cloudsqladmin ERROR: function postgis_full_version() does not exist at character 8

Not sure what this mean though 😞

[DamianS]

Gemini says that this is related with CloudSQL extension, however it says nothing to me. Please see response :

[dataspun]

Experiencing same issues reported by @jaebum.

The error related to postgis version seems particularly concerning, because it's being reported on databases that do not have the extension installed.