An Azure managed PostgreSQL database service for app development and deployment.
Error Updating Postgresql Database Version
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.