Unable to upgrade Postgresql Flexible Server from V14 to V16

Question

Dear Azure Support, I would like to do a major upgrade of Postgres Flexible Server from V14 to V16.

I always get the following error message, although I have removed extensions dblink and postgres_fdw.

PS C:\Program Files\PowerShell\7> az postgres flexible-server upgrade -g ww-dev-postgres-dbmc -n ww-dev-postgres-mobile-dbmc -v 16 -y

(MajorVersionUpgradeFailedPrecheck) The major version upgrade failed precheck. Upgrading extension dblink in database wwcore from source version 14 to target version 16 is not supported.

Code: MajorVersionUpgradeFailedPrecheck Message: The major version upgrade failed precheck.

Upgrading extension dblink in database wwcore from source version 14 to target version 16 is not supported.

SubscriptionId: e0a9544a-1aec-4d31-a0c4-6703773e1bc6

Ressource Group: ww-dev-postgres-dbmc

Servername: http://ww-dev-postgres-mobile-dbmc.postgres.database.azure.com

What is the reason for the error message?

Thanks in advance. Martin

Answer 1

Hi @Martin Constam,

Thanks for the question and using MS Q&A platform.

It seems like you are getting error message while upgrading from PostgreSQL Flexible Server from V14 to V16

During the process of an in-place major version upgrade, Azure Database for PostgreSQL flexible server runs a pre-check procedure to identify any potential issues that might cause the upgrade to fail.

If the pre-check finds any incompatibilities, it creates a log event that shows that the upgrade pre-check failed, along with an error message.

If pre-check operations fail for an in-place major version upgrade, the upgrade fails with a detailed error message for all the following limitations:

• In-place major version upgrades don't support certain extensions, and there are some limitations to upgrading certain extensions. The following extensions are unsupported for all PostgreSQL versions: Timescaledb, pgaudit, dblink, orafce, pg_partman, postgres_fdw
• ervers configured with logical replication slots aren't supported.
• Servers using SSDv2 storage do not support Major Version Upgrades.
• In-place major version upgrades currently don't support read replicas. If you have a server that acts as a read replica, you need to delete the replica before you perform the upgrade on the primary server. After the upgrade, you can re-create the replica.
• Azure Database for PostgreSQL - Flexible Server requires the ability to send and receive traffic to destination ports 5432 and 6432 within the virtual network where the flexible server is deployed, and to Azure Storage for log archiving.

For more information, please go through this documentation: Major version upgrades in Azure Database for PostgreSQL - Flexible Server.

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Hi

I am also having the same issue and I can't find the log, the only error I can see is below

error.png

Thanks