Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
PostgreSQL flexible server stuck in dropping after quota increase
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 86%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jarvis
20
Reputation points
Received an error when originally deploying a postgreSQL flexible server in East US via Terraform:
Status: "LocationIsOfferRestricted" │ Code: "" │ Message: "Subscriptions are restricted from provisioning in location 'eastus'. Try again in a different location. For exceptions to this rule, see how to request a quota increase in https://aka.ms/postgres-request-quota-increase"
I then proceeded to make a ticket to increase my quota, got it approved, and tried re-running the terraform apply. The server is stuck in "Dropping" status.
Azure Database for PostgreSQL
{count} votes
-
Jarvis 20 Reputation points
2025-10-27T20:25:57.3+00:00 New error messages:
│ Status: "InternalServerError"│ Code: ""
│ Message: "An unexpected error occured while processing the request. Tracking ID: '243d73c0-ee66-462d-94da-4c3138e270ae'"
│ Activity Id: ""
│
│ ---
│
│ API Response:
│
│ ----[start]----
│ {"name":"fe0e1317-7aae-4a8a-ad71-c3b13363fa7f","status":"Failed","startTime":"2025-10-27T20:19:10.817Z","error":{"code":"InternalServerError","message":"An unexpected error occured while processing the request. Tracking ID: '243d73c0-ee66-462d-94da-4c3138e270ae'"}}
│ -----[end]-----
│ Status: "LocationIsOfferRestricted"
│ Code: ""
│ Message: "Subscriptions are restricted from provisioning in location 'eastus'. Try again in a different location. For exceptions to this rule, see how to request a quota increase in https://aka.ms/postgres-request-quota-increase."
│ Activity Id: ""
│
│ ---
│
│ API Response:
│
│ ----[start]----
│ {"name":"xxxxx","status":"Failed","startTime":"2025-10-27T20:19:12.47Z","error":{"code":"LocationIsOfferRestricted","message":"Subscriptions are restricted from provisioning in location 'eastus'. Try again in a different location. For exceptions to this rule, see how to request a quota increase in https://aka.ms/postgres-request-quota-increase."}}
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 72%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Swapnesh Panchal 740 Reputation points Microsoft External Staff Moderator2025-10-27T23:22:49.85+00:00 Hi Jarvis,
Welcome to the Microsoft Q&A and thank you for posting your questions here.
Please proceed with the cleanup and retry steps below.- Remove RG/server locks.
- Delete any Private Endpoints + Private DNS zone links referencing the server.
- Re-issue delete:
az resource delete --ids $(az postgres flexible-server show -g <rg> -n <server> --query id -o tsv)
Please share the possible evidence and required additional details in a private message.
Latest delete attempt: Activity Log Correlation ID + UTC time (Microsoft.DBforPostgreSQL/flexibleServers/delete)
Outputs:
az postgres flexible-server show -g <rg> -n <server> -o json
az lock list -g <rg> -o table -
Jarvis 20 Reputation points
2025-10-28T16:53:20.25+00:00 @Swapnesh Panchal I get this error:
(ResourceNotFound) The requested resource of type 'Microsoft.DBforPostgreSQL/flexibleServers' with name 'xxxxx' was not found.Code: ResourceNotFound
Message: The requested resource of type 'Microsoft.DBforPostgreSQL/flexibleServers' with name 'xxxxx' was not found.
Also getting a new error as well:
module.notification-service["prod"].azurerm_postgresql_flexible_server.managed_pg_server_prod[0]: Creating...╷
│ Error: creating Flexible Server (Subscription: "xxxxx"
│ Resource Group Name: "managed-postgres-prod"
│ Flexible Server Name: "notification-service-postgres-prod"): performing Create: unexpected status 409 (409 Conflict) with error: InvalidResourceLocation: The resource 'notification-service-postgres-prod' already exists in location 'eastus' in resource group 'managed-postgres-prod'. A resource with the same name cannot be created in location 'westus3'. Please select a new resource name.
│
│ with module.notification-service["prod"].azurerm_postgresql_flexible_server.managed_pg_server_prod[0],
│ on modules/database/database.tf line 102, in resource "azurerm_postgresql_flexible_server" "managed_pg_server_prod":
│ 102: resource "azurerm_postgresql_flexible_server" "managed_pg_server_prod" {
Sign in to comment
Sign in to answer