This document indicates that PostGIS needs to be updated before a major version upgrade. And, this list shows the supported PostGIS version under PostgreSQL 13.11 is 3.3.2.
I have upgrade postgis to 3.3.2. But when I try to upgrade db engine it shows the error that precheck failed.
The instance could not be upgraded from 12.15.R1 to 13.11.R2 because of following reasons. Please take appropriate action on databases that have usages incompatible with requested major engine version upgrade and try again.
- Following usages in database 'postgres' need to be corrected before upgrade:
-- The instance could not be upgraded because there are one or more databases with an older version of PostGIS extension or its dependent extensions (address_standardizer, address_standardizer_data_us, postgis_tiger_geocoder, postgis_topology, postgis_raster) installed. Please upgrade all installations of PostGIS and drop its dependent extensions and try again.
All the rest extension mentioned are not installed was verified.
Only thing not done right now is drop postgis directly as suggested here as I did not understand the repercursion of same.
Any suggestions on how to proceed?
AWS OFFICIALUpdated 3 years ago
We are also having this issue, but trying to upgrade from Postgres 11.2. We have updated the Postgis extension to 3.3.3, which is listed as compatible with both our current version (11.2) and target version (16.1). But our upgrade/precheck logs shows the exact same error.
@repost_umang did you ever find a solution?