Cannot update PostGIS

halfhp · 05-24-2022 05:55 AM

I've got a Postgres 11 Instance that I'd like to upgrade to 12+. Unfortunately the in-place upgrade fails because of an older version of PostGIS:

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

When I attempt to update PostGIS I get an error as well:

It appears that a bunch of tables are owned by the cloudsqladmin user, which I as an end user have no access to (so far as I've seen or read). How is one supposed to be able to 1) upgrade PostGIS or 2) upgrade Postgres if this is the case?

Andre_Fiesco

According to the error you are getting, it is an issue with permissions [1]. Are you the owner of the database? Also check with the admin of the database and see what permissions you have.

[1]:https://www.paessler.com/help/postgre-sql-errors#:~:text=PostgreSQL%20error%2042501%20is%20a,respond...