Scaling issues in Azure Database for PostgreSQL Flexible Server especially when it gets stuck in the "Starting" or "Updating" state can be caused by various underlying factors.
Below is a step-by-step breakdown of causes and recommended resolution steps:
-- Ongoing or Failed Prior Operations:
Scaling won’t proceed if a previous operation (e.g., maintenance, backup, parameter update) is still running or failed.
Check via Activity Log and Look for operations in InProgress
or Failed
state with error messages.
Azure Portal > Monitor > Activity Log
-- Unsupported Scaling Path:
Cross-tier scaling often requires a restart or fails silently. Scale within the same tier first (e.g., GP 2 vCore to GP 4 vCore).
az postgres flexible-server update \
--resource-group <rg> \
--name <server> \
--sku-name Standard_D4s_v3
-- Maintenance or Engine Upgrade in Progress:
az postgres flexible-server show --resource-group <rg> --name <server> --query "maintenanceWindow"
-- VNet or NSG Misconfiguration:
If in a VNet, check that NSGs and route tables allow required traffic for Azure control plane.
-- Resource Locks or Policy Restrictions:
az lock list --resource-group <rg>
Check for reference - az postgres flexible-server