Upgrading Azure Database for PostgreSQL flexible server to version 16

Question

When trying to upgrade a PostgreSQL server from 15 to 16 I'm getting the following error:

You are already running the latest major PostgreSQL version available.

It is possible to create a new Azure Database for PostgreSQL flexible server with version 16.

Answer 1

Hi Jonas Kvinge •,

I have checked with the internal team and got below reply:

The “In-Place Major Version Upgrade” (MVU) functionality for PG16 is not yet available, and this is being currently worked.

You can however still create a new Flex PG instance on Postgres 16 (hence the doc says it is supported).

Hope this helps.

We appreciate your patience until this functionality gets generally available.

Thanks

Answer 2

Hi Jonas Kvinge •,

We are sorry about the inconvenience caused to you.

We recommend you to perform migration through Azure CLI https://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-single-to-flexible-cli until the issue is resolved.

Thanks for your cooperation.

Answer 3

I offer you to follow this link

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

If in-place major version upgrade pre-check operations fail, then the upgrade aborts with a detailed error message for all the below limitations.