Unable to upgrade Postgres 11.22 on Azure Database for PostgreSQL flexible server to Postgres 17

Question

We have a postgres version 11.22 on PostgresSQL flexible server that we are testing the migration from version 11 to version 17.

Using the inbuild upgrade feature, the Postgres server shows

"The server is currently in 'upgrading major version' state. Please wait for the operation to complete. You can refresh to check status. Reach out to Microsoft support if the operation is taking too long."

but never completes. How can i reach out to Microsoft Support for this?

Answer 1

Hello **Gerald Tan
**Glad that the server is back to online state. But in future, if you have similar issue, the below steps will help you in finding the basic cause.

• Major-version upgrades can take anywhere from a few minutes to a couple of hours depending on your database size, workload and whether there were any pre-checks to run (extensions to drop, pending restarts, etc.).

• If after 2–3 hours you still see “upgrading major version” with no progress, it’s time to dig deeper.

• Make sure you’ve enabled the PostgreSQL flexible upgrade logs so you can see where it’s getting stuck. • In the Azure portal go to your flexible server > Server parameters > Enable “capture upgrade logs”.

Run pre-upgrade checks • Remove unsupported extensions or pending-restart configuration changes before you kick off the upgrade—those are common blockers.

• Verify no read replicas or logical replication slots exist.

https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-major-version-upgrade#upgrade-considerations-and-limitations

In future if you face any such kind of issues, please reach out to us, we will help you in mitigating it.