Cannot Upgrade Postgresql Flexible Server to V14

Ryan H 0

I'm trying to upgrade my azure postgresql flexible server v13 instance to v14, and keep getting the standard InternalServerError "An unexpected error occured while processing the request." error.

I've also followed the full upgrade instructions to no success: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-major-version-upgrade

I made sure all the correct extensions are disabled, outside 1 problem, where I see dblink enabled on my db when querying it directly, however it's not enabled when looking in the portal via Settings-Server Parameters->azure.extensions. I can't disable it in the database due to the db being setup as a service, and not providing full permissions even with the default admin user. I've also tried upgrading directly to v15, and that didn't work. I see there's a lot of others posting about this, but does anyone have any conclusive results on how to do this properly?

Mallaiah Sangi 85 Reputation points Microsoft Vendor

2025-02-26T19:46:16.0333333+00:00

Hi @Ryan H

Thanks for the Question and using Microsoft Q&A

As per my understanding, you are not able to be upgrading postgresql flexible server v13 instance to v14.

It looks like a service limitation when upgrading from a lower version to a higher version.

The following extensions are unsupported for all PostgreSQL versions: Timescaledb, pgaudit, dblink, orafce, pg_partman, postgres_fdw.

Please ensure that unsupported extensions are followed for all PostgreSQL versions. As mentioned in the error description, dblink is enabled on your database, and querying it directly may cause issues during your upgrade.

Please following unsupported extensions for all PostgreSQL versions.

documentation link: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-major-version-upgrade

I hope this information helps. Please do let us know if you have any further queries.
Mallaiah Sangi 85 Reputation points Microsoft Vendor

2025-02-27T20:37:33.48+00:00

Hi @Ryan H

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Cannot Upgrade Postgresql Flexible Server to V14

Your answer