IssueTracker

Problem you have encountered:

In a Cloud SQL PostgreSQL instance of major version 9.6, 10, or 11, when a database user tries to upgrade the PostGIS extension, the following error happens:

postgres=> ALTER EXTENSION postgis UPDATE TO '3.0.3';
ERROR: permission denied to set parameter "cloudsql.extension_maintenance"

What you expected to happen:

The upgrade should succeed without error.

Steps to reproduce:

Execute ALTER EXTENSION postgis UPDATE TO '3.0.3'

Other information (workarounds you have tried, documentation consulted, etc):

In Cloud SQL PostgreSQL, before users upgrade the database major version in-place, one required preparation is to update the PostGIS extension. PostgreSQL 9.6 to 11 users with an old PostGIS extension will encounter this error during upgrade.