An Azure managed PostgreSQL database service for app development and deployment.
Hi,
Unfortunately new deployments of PostgreSQL Flexible Server Burstable SKUs are blocked in some regions. The only way around it in my experience is to use a different SKU such as General Purpose or deploy in a different region that isn't blocked yet. It isn't only your subscription, or only East US/East US 2.
Below is excerpt from documentation on how to resolve this error:
SKU not available
If you encounter the following error, select a different SKU type. Availability of SKU may differ across regions, either the specific SKU isn't supported in the region or temporarily unavailable. Specified SKU is not supported in this region. Please choose a different SKU.
To provide more context, the underlying VM sizes for PostgreSQL Flexible Burstable SKUs are being retired, and they are currently subject to growth restrictions and capacity limitations. Many subscriptions are blocked from creating these sizes at all, whereas others that already have them are unable to get additional quota and/or may see failures if they deallocate and try to start VM later.
There hasn't been official guidance that I am aware of as to what will happen and when with these Burstable SKUs. For instance, there are Bsv2 burstable VM sizes that are supposed to replace the retiring ones. Will they switch PostgreSQL Flexible to use these as the underlying VMs for Burstable SKUs at some point? By the way, these Bsv2 series sizes can be difficult to obtain quota for, even though they are not deprecated.
Recently I was able to create PostgreSQL Burstable SKU in West US 2, which is in part why I know that not all regions are blocking them. In months past I've created them in other regions as well, but I don't remember specific regions.
One option to consider would be to use General Purpose v5 SKU with a 3 year reservation. That way you can get the monthly cost down as low as possible.
Thanks.
-TP