Azure Database for PostgreSQL Flexible Server Stuck in Dropping State after delete

Petko Stoyanov 0 Reputation points
2026-09-03T07:55:37.77+00:00

Hello,

I am experiencing an issue with an Azure Database for PostgreSQL Flexible Servers that are stuck in the "Dropping" state.

The servers have been showing the "Dropping" status for approximately 20** **hours and the operation does not appear to be progressing.

At first, I assumed the process required additional time to complete, but given the amount of time that has passed, I suspect there may be an issue preventing the operation from finishing.

Has anyone encountered a similar problem, or are there any troubleshooting steps I can perform to determine what is blocking the deletion?

Any guidance or help would very be appreciated.

Thank you.

Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
  1. Deepanshu katara 18,230 Reputation points MVP Volunteer Moderator
    2026-09-03T09:20:22.85+00:00

    Hello , Welcome to MS Q&A

    This looks like an Azure “ghost resource” issue where the Azure Resource Manager (ARM) and the PostgreSQL service are not in sync.

    ARM thinks the PostgreSQL server has already been deleted or is still being deleted, which is why it returns “resource doesn’t exist” when you try to delete it.

    However, the PostgreSQL backend still has the server recorded, so when you try to create a new server with the same name, it says the resource already exists.

    Because the resource is stuck in this state, the resource group also cannot be deleted normally.

    The first thing to try is a direct ARM deletion using the resource ID:

    az resource delete --ids "<FULL-RESOURCE-ID>"
    

    After running this, wait a few minutes and check the Azure portal again.

    If that doesn't work, try using Azure Resource Explorer:

    https://resources.azure.com/

    Go to your subscription → Resource Groups → your resource group → Microsoft.DBforPostgreSQL → flexibleServers.

    Find the stuck PostgreSQL server, select it, and use the Delete option to send a direct delete request.

    Basically, the issue is that Azure's different services have different states for the same resource. The goal is to force the resource to be deleted and get everything back in sync.

    Pls check and let me know if any further ques

    Thanks

    Deepanshu

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.