Why does the major version update fail when postgis is installed

Richard Huesken 1 Reputation point
2025-01-12T13:06:16.08+00:00

The serverlogs show the following error when doing a major version upgrade from postgres version 14 to version 16. Installed postgis, postgis_raster and postgis_sfcgal.

ERROR

0A000

SELECT public.postgis_extensions_upgrade()

UTC-6783af44.35b-azuresu-msg_dev-ERROR: 0A000: updating an extension to a specific version is not supported

Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,047 questions
Azure Database for PostgreSQL
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.