PostgreSQL flexible server stuck in dropping after quota increase

Question

PostgreSQL flexible server stuck in dropping after quota increase

Jarvis 20

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.

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."}}
Swapnesh Panchal 1,380 Reputation points Microsoft External Staff Moderator

2025-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" {
Swapnesh Panchal 1,380 Reputation points Microsoft External Staff Moderator

2025-11-06T13:54:26.1233333+00:00
Thank you for sharing the details. I understand you’re unable to create PostgreSQL Flexible Servers in East US since Sept 28 and are consistently hitting Internal Server Error, leaving the server stuck in Dropping state.

At this point, I recommend the following next steps:

retry a different East US sub-region (if available) – e.g., East US 2 – to see if the behavior is isolated to a single zone.

Please let me know if the issue persists after checking.

Hope this helps. Do let us know if you any further queries.

Jarvis 20

UPDATE: I'm seeing this message with the azure cli for eastus:

"reason": "Provisioning is restricted in this region. Please choose a different region. For exceptions to this rule please open a support request with Issue type of 'Service and subscription limits'.",

az postgres flexible-server list-skus --location eastus               
For prices please refer to https://aka.ms/postgres-pricing
[
  {
    "fastProvisioningSupported": "Enabled",
    "geoBackupSupported": "Enabled",
    "indexTuningSupported": "Enabled",
    "name": "FlexibleServerCapabilities",
    "onlineResizeSupported": "Enabled",
    "reason": "Provisioning is restricted in this region. Please choose a different region. For exceptions to this rule please open a support request with Issue type of 'Service and subscription limits'.",
    "restricted": null,
    "status": null,
    "storageAutoGrowthSupported": "Enabled",
    "supportedFastProvisioningEditions": [
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "12",
        "supportedSku": "standard_b1ms",
        "supportedStorageGb": 32,
        "supportedTier": "Burstable"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "12",
        "supportedSku": "standard_b2s",
        "supportedStorageGb": 32,
        "supportedTier": "Burstable"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "12",
        "supportedSku": "standard_d2s_v3",
        "supportedStorageGb": 128,
        "supportedTier": "GeneralPurpose"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "12",
        "supportedSku": "standard_d2ds_v4",
        "supportedStorageGb": 128,
        "supportedTier": "GeneralPurpose"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "12",
        "supportedSku": "standard_e2ds_v4",
        "supportedStorageGb": 512,
        "supportedTier": "MemoryOptimized"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "13",
        "supportedSku": "standard_b1ms",
        "supportedStorageGb": 32,
        "supportedTier": "Burstable"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "13",
        "supportedSku": "standard_b2s",
        "supportedStorageGb": 32,
        "supportedTier": "Burstable"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "13",
        "supportedSku": "standard_d2s_v3",
        "supportedStorageGb": 128,
        "supportedTier": "GeneralPurpose"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "13",
        "supportedSku": "standard_d2ds_v4",
        "supportedStorageGb": 128,
        "supportedTier": "GeneralPurpose"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "13",
        "supportedSku": "standard_e2ds_v4",
        "supportedStorageGb": 512,
        "supportedTier": "MemoryOptimized"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "14",
        "supportedSku": "standard_b1ms",
        "supportedStorageGb": 32,
        "supportedTier": "Burstable"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "14",
        "supportedSku": "standard_b2s",
        "supportedStorageGb": 32,
        "supportedTier": "Burstable"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "14",
        "supportedSku": "standard_d2s_v3",
        "supportedStorageGb": 128,
        "supportedTier": "GeneralPurpose"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "14",
        "supportedSku": "standard_d2ds_v4",
        "supportedStorageGb": 128,
        "supportedTier": "GeneralPurpose"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "14",
        "supportedSku": "standard_e2ds_v4",
        "supportedStorageGb": 512,
        "supportedTier": "MemoryOptimized"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "15",
        "supportedSku": "standard_b1ms",
        "supportedStorageGb": 32,
        "supportedTier": "Burstable"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "15",
        "supportedSku": "standard_b2s",
        "supportedStorageGb": 32,
        "supportedTier": "Burstable"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "15",
        "supportedSku": "standard_d2s_v3",
        "supportedStorageGb": 128,
        "supportedTier": "GeneralPurpose"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "15",
        "supportedSku": "standard_d2ds_v4",
        "supportedStorageGb": 128,
        "supportedTier": "GeneralPurpose"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "15",
        "supportedSku": "standard_e2ds_v4",
        "supportedStorageGb": 512,
        "supportedTier": "MemoryOptimized"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "16",
        "supportedSku": "standard_b1ms",
        "supportedStorageGb": 32,
        "supportedTier": "Burstable"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "16",
        "supportedSku": "standard_b2s",
        "supportedStorageGb": 32,
        "supportedTier": "Burstable"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "16",
        "supportedSku": "standard_d2s_v3",
        "supportedStorageGb": 128,
        "supportedTier": "GeneralPurpose"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "16",
        "supportedSku": "standard_d2ds_v4",
        "supportedStorageGb": 128,
        "supportedTier": "GeneralPurpose"
      },
      {
        "reason": null,
        "serverCount": 0,
        "status": null,
        "supportedServerVersions": "16",
        "supportedSku": "standard_e2ds_v4",
        "supportedStorageGb": 512,
        "supportedTier": "MemoryOptimized"
      }
    ],
    "supportedFeatures": [
      {
        "name": "FastProvisioning",
        "status": "Enabled"
      },
      {
        "name": "ZoneRedundantHa",
        "status": "Disabled"
      },
      {
        "name": "GeoBackup",
        "status": "Enabled"
      },
      {
        "name": "ZoneRedundantHaAndGeoBackup",
        "status": "Enabled"
      },
      {
        "name": "StorageAutoGrowth",
        "status": "Enabled"
      },
      {
        "name": "OnlineResize",
        "status": "Enabled"
      },
      {
        "name": "OfferRestricted",
        "status": "Enabled"
      },
      {
        "name": "IndexTuning",
        "status": "Enabled"
      },
      {
        "name": "Clusters",
        "status": "Enabled"
      },
      {
        "name": "ConfigTuning",
        "status": "Disabled"
      }
    ],
    "supportedServerEditions": [],
    "supportedServerVersions": [],
    "zoneRedundantHaAndGeoBackupSupported": "Enabled",
    "zoneRedundantHaSupported": "Disabled"
  }
]

Jarvis 20

And this terraform error:

╷
│ Error: creating Flexible Server (Subscription: "xxxxx" │ Resource Group Name: "managed-postgres-prod"
│ Flexible Server Name: "test-testing-service-postgres-prod"): polling after Create: polling failed: the Azure API returned the following error:
│ 
│ 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":"84241405-a994-48e8-aa38-cf79f9514c77","status":"Failed","startTime":"2025-11-06T15:52:08.45Z","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."}}
│ -----[end]-----
│ 
│ 
│   with module.test-testing-service["prod"].azurerm_postgresql_flexible_server.managed_pg_server_prod[0],
│   on modules/database/database.tf line 103, in resource "azurerm_postgresql_flexible_server" "managed_pg_server_prod":
│  103: resource "azurerm_postgresql_flexible_server" "managed_pg_server_prod" {
│ 
╵
Error: Process completed with exit code 1.

Manoj Kumar Boyini 1,330 Reputation points Microsoft External Staff Moderator

2025-11-07T07:30:47.64+00:00

Hi Jarvis,

Upon further investigation, we found that the issue originates from the infrastructure side. Currently, the East US region has provisioning restrictions for PostgreSQL Flexible Server. When the initial deployment failed, the resource became stuck in a partially deleted state, which means the name remains in the backend even though it is no longer visible in the portal.

As a result, any attempt to deploy a new resource with the same name in a different region results in an “InvalidResourceLocation” or “LocationIsOfferRestricted” error.

Please create the server in an alternative region, such as East US 2 or West US 3, and use a new name. This approach typically resolves the issue promptly migrating to new region or SKU.

Please let us know if you have any questions or concerns.

1 answer

Your answer

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."}}
Swapnesh Panchal 1,380 Reputation points Microsoft External Staff Moderator

2025-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" {
Swapnesh Panchal 1,380 Reputation points Microsoft External Staff Moderator

2025-11-06T13:54:26.1233333+00:00

Thank you for sharing the details. I understand you’re unable to create PostgreSQL Flexible Servers in East US since Sept 28 and are consistently hitting Internal Server Error, leaving the server stuck in Dropping state.

At this point, I recommend the following next steps:

retry a different East US sub-region (if available) – e.g., East US 2 – to see if the behavior is isolated to a single zone.

Please let me know if the issue persists after checking.

Hope this helps. Do let us know if you any further queries.
Jarvis 20 Reputation points

2025-11-06T15:54:36.2566667+00:00

And this terraform error:

╷ │ Error: creating Flexible Server (Subscription: "xxxxx" │ Resource Group Name: "managed-postgres-prod" │ Flexible Server Name: "test-testing-service-postgres-prod"): polling after Create: polling failed: the Azure API returned the following error: │ │ 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":"84241405-a994-48e8-aa38-cf79f9514c77","status":"Failed","startTime":"2025-11-06T15:52:08.45Z","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."}} │ -----[end]----- │ │ │ with module.test-testing-service["prod"].azurerm_postgresql_flexible_server.managed_pg_server_prod[0], │ on modules/database/database.tf line 103, in resource "azurerm_postgresql_flexible_server" "managed_pg_server_prod": │ 103: resource "azurerm_postgresql_flexible_server" "managed_pg_server_prod" { │ ╵ Error: Process completed with exit code 1.
Manoj Kumar Boyini 1,330 Reputation points Microsoft External Staff Moderator

2025-11-07T07:30:47.64+00:00

Hi Jarvis,

Upon further investigation, we found that the issue originates from the infrastructure side. Currently, the East US region has provisioning restrictions for PostgreSQL Flexible Server. When the initial deployment failed, the resource became stuck in a partially deleted state, which means the name remains in the backend even though it is no longer visible in the portal.

As a result, any attempt to deploy a new resource with the same name in a different region results in an “InvalidResourceLocation” or “LocationIsOfferRestricted” error.

Please create the server in an alternative region, such as East US 2 or West US 3, and use a new name. This approach typically resolves the issue promptly migrating to new region or SKU.

Please let us know if you have any questions or concerns.

Answer 1

Jarvis 20

Created quota ticket to Service and subscription Team. Having them check Quota, Region is allowlisted and Subscription is whitelisted.

Swapnesh Panchal 1,380 Reputation points Microsoft External Staff Moderator

2025-11-10T22:29:12.9266667+00:00

sure, If any help is required from our side, please let us know.

Share via

PostgreSQL flexible server stuck in dropping after quota increase

1 answer

Your answer