Azure flexible server for Postgresql support for GP_Standard_D4s_v3 & GP_Standard_D2s_v3 in East US region

Question

Hi, We wanted to create Azure Flexible server for postgresql in East US and East US 2 regions. But we could not find "GP_Standard_D4s_v3 & GP_Standard_D2s_v3" options in East US region.

But below link mentions that East US and East US2 has support for v3/v4 SKU. https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/overview

Even pricing calculator displays these options. https://azure.microsoft.com/en-us/pricing/details/postgresql/flexible-server/

If we try create D2s V3 in East US region using terraform, scripts fails with below error.

module.m_psql_server.azurerm_postgresql_flexible_server.gcapp_db_server: Still creating... [59m50s elapsed]

│ Error: creating Flexible Server (Subscription: "6974b4cf-6bf8-4454-8d22-a8f33084d699"
│ Resource Group Name: "gcapp-lab-deploy-eu-aram"
│ Flexible Server Name: "gcapp-db-server-awldkarfdrfo"): polling after Create: context deadline exceeded
│ 
│   with module.m_psql_server.azurerm_postgresql_flexible_server.gcapp_db_server,
│   on ../tf_modules/psql_module/main.tf line 10, in resource "azurerm_postgresql_flexible_server" "gcapp_db_server":
│   10: resource "azurerm_postgresql_flexible_server" "gcapp_db_server" {
│ 
╵

We wanted to select SKU which works for all the regions. Could you please suggest one SKU?

Answer 1

Hi,

There appears to be a bug in portal where it isn't showing available Intel options.

As a test, please use below powershell commands in Azure Cloud Shell to create Azure Database for PostgreSQL Flexible server in East US and East US 2 regions. When finished you should have two Standard_D2s_v3 servers, one in East US and the other in East US 2.

$dbEastus = New-AzPostgreSqlFlexibleServer -Location eastus
$dbEastus
$dbEastus2 = New-AzPostgreSqlFlexibleServer -Location eastus2
$dbEastus2

Once the above two commands are finished, please navigate to the servers in the portal and click on Compute + storage blade. Click the Compute size dropdown and notice all the options available.

IMPORTANT: When finished testing, make sure to delete the two resource groups that were automatically created above so that charges do not continue to accrue.

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP