PSQL flexible server is in 'updating' state too long. Can't do anything with instance and databases.

Michał Salasa 0 Reputation points
2024-06-14T08:50:33.0466667+00:00

I decided to upgrade from GUI Compute size of my PostgreSQL flexible server from Standard_B1ms (1vC, 2GB) to Standard_B2s (2vC, 4GB). Unfortunately, it is running about 24 hours (status "Updating"), and I can't do anything, even stop the update or stop/start the instance. Databases are still working and I can use them, but I have no control over the server. Where is the problem and how to solve it?

Region: westeurope; PostgreSQL version: 16.2; HighAvability: Not enabled.

Azure Database for PostgreSQL
{count} votes

1 answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 14,201 Reputation points Microsoft Employee
    2024-06-14T09:41:30.4966667+00:00

    Hi Michał Salasa •,

    Welcome to Microsoft Q&A forum.

    This could be due to heavy load, rescaling operation etc.

    Please try using Azure CLI if helps.

    For this issue, we recommend you to raise support case for solution.

    Let us know if you need any assistance in doing the same.

    Thanks

    0 comments No comments