Error Updating Postgresql Database Version

Todd Player 0 Reputation points
2026-07-30T17:35:04.09+00:00

Hello,:

I am trying to upgrade a postgresql instance major version and getting this error:

{

"code": "MajorVersionUpgradeFailedPrecheck",

"message": "The major version upgrade failed precheck. Upgrading with certain extensions in schema not in search_path is disallowed. Found extension postgis_topology in schema topology in database actionhub_prod not in search_path "$user", public."

}

The database has PostGIS installed and I have run the normal troubleshooting to determine the search_path is correct. A show search_path query returns: """$user""", public, topology. Checking for roles that could override that seems to be the issue. The azuresu has a different search path but I cannot update it because my admin account is not a superuser account. An AI search suggests the only one that can fix this is Microsoft support so I'm reaching out to get connected.

Azure Database for PostgreSQL

Your answer

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