Postgres db stuck in a "dropping" state

C P 20 Reputation points
2025-06-02T10:31:53.7+00:00

az postgres flexible-server show \

--name blueprint-app-db-server \

--resource-group blueprint-pulumi-rg

{

"administratorLogin": null,

"administratorLoginPassword": null,

"authConfig": null,

"availabilityZone": null,

"backup": {

"backupRetentionDays": null,

"earliestRestoreDate": null,

"geoRedundantBackup": "Disabled"

},

"cluster": null,

"createMode": null,

"dataEncryption": {

"geoBackupEncryptionKeyStatus": null,

"geoBackupKeyUri": null,

"geoBackupUserAssignedIdentityId": null,

"primaryEncryptionKeyStatus": null,

"primaryKeyUri": null,

"primaryUserAssignedIdentityId": null,

"type": "SystemManaged"

},

"fullyQualifiedDomainName": "blueprint-app-db-server.postgres.database.azure.com",

"highAvailability": null,

"id": "/subscriptions/resourceGroups/blueprint-pulumi-rg/providers/Microsoft.DBforPostgreSQL/flexibleServers/blueprint-app-db-server",

"identity": null,

"___location": "UK South",

"maintenanceWindow": null,

"minorVersion": null,

"name": "blueprint-app-db-server",

"network": {

"delegatedSubnetResourceId": null,

"privateDnsZoneArmResourceId": null,

"publicNetworkAccess": "Disabled"

},

"pointInTimeUtc": null,

"privateEndpointConnections": null,

"replica": {

"capacity": null,

"promoteMode": null,

"promoteOption": null,

"replicationState": null,

"role": null

},

"replicaCapacity": null,

"replicationRole": null,

"resourceGroup": "blueprint-pulumi-rg",

"sku": {

"name": "Standard_B1ms",

"tier": "Burstable"

},

"sourceServerResourceId": null,

"state": "Dropping",

"storage": {

"autoGrow": "Disabled",

"iops": null,

"storageSizeGb": 32,

"throughput": null,

"tier": null,

"type": null

},

"systemData": null,

"tags": {

"environment": "production",

"project": "blueprint-app"

},

"type": "Microsoft.DBforPostgreSQL/flexibleServers",

"version": "14"

}

Unable to delete resource group or postgres.

$ az postgres flexible-server delete --resource-group blueprint-pulumi-rg --name blueprint-app-db-server --yes

(ResourceNotFound) The requested resource of type 'Microsoft.DBforPostgreSQL/flexibleServers' with name 'blueprint-app-db-server' was not found.

Code: ResourceNotFound

Message: The requested resource of type 'Microsoft.DBforPostgreSQL/flexibleServers' with name 'blueprint-app-db-server' was not found.

(ResourceNotFound) The requested resource of type 'Microsoft.DBforPostgreSQL/flexibleServers' with name 'blueprint-app-db-server' was not found.

Code: ResourceNotFound

Message: The requested resource of type 'Microsoft.DBforPostgreSQL/flexibleServers' with name 'blueprint-app-db-server' was not found.

Azure Database for PostgreSQL
{count} votes

Accepted answer
  1. Saraswathi Devadula 4,605 Reputation points Microsoft External Staff Moderator
    2025-06-02T12:39:50.4833333+00:00

    Hello C P
    Following up on the discussion, the Azure Database for PostgreSQL Flexible Server in the Azure portal is currently stuck in the dropping state.

    As mentioned, we attempted to drop the server from the backend.

    I hope this has been helpful!

    Your feedback is important so please take a moment to accept answers. If you still have questions, please let us know what is needed in the comments so the question can be answered. Thank you for helping to improve Microsoft Q&A!

    If this answers your query, do click Accept Answer and Upvote for was this answer helpful.

    User's image


0 additional answers

Sort by: Most helpful

Your answer

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