[azurerm_postgresql_flexible_server] Support for In Preview Storage Type: Premium SSD V2

[pk0ps]

Is there an existing issue for this?

• I have searched the existing issues

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment and review the contribution guide to help.

Description

Hello,
there is a feature In Preview for Premium SSD V2 storage disks which is cheaper and flexible for tuning. It would be great to have azurerm_postgresql_flexible_server resource parameters for configuring such as disk type, IOPS and throughput besides disk size.

New or Affected Resource(s)/Data Source(s)

azurerm_postgresql_flexible_server

Potential Terraform Configuration

resource "azurerm_postgresql_flexible_server" "example" {
  name                   = "example-psqlflexibleserver"
  resource_group_name    = azurerm_resource_group.example.name
  location               = azurerm_resource_group.example.location
  version                = "12"
  delegated_subnet_id    = azurerm_subnet.example.id
  private_dns_zone_id    = azurerm_private_dns_zone.example.id
  administrator_login    = "psqladmin"
  administrator_password = "H@Sh1CoR3!"
  zone                   = "1"

  storage_mb = 32768
  storage_type = "PremiumV2"
  storage_iops = 3000
  storage_throughput = 125

  sku_name   = "GP_Standard_D4s_v3"
  depends_on = [azurerm_private_dns_zone_virtual_network_link.example]
}

References

• https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-compute-storage#premium-ssd-v2-preview

[jonasmock]

Any updates? I'm not sure if its still in preview but I would like to configure this as well in Terraform.

[hmasum52]

any updates?

[rmcolbert]

Ultradisk has now been added as a valid storage_type ... so it would be nice if this was added.

[hmasum52]

Ultradisk has now been added as a valid storage_type ... so it would be nice if this was added.

@rmcolbert Does it mean we can provision Premium SDD V2 for the Postgresql flexible server?

[rmcolbert]

Ultradisk has now been added as a valid storage_type ... so it would be nice if this was added.

@rmcolbert Does it mean we can provision Premium SDD V2 for the Postgresql flexible server?

It means Microsoft has added Ultradisk to the list of available storage types. The provider is still lacking the feature to set the storage type.

[neil-yechenwei]

Service team plans to release it on May. Maybe azapi provider won't block you.

[ACU-jay]

any updates on this?

[neil-yechenwei]

It's still in public preview. See more details from https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-storage#premium-ssd-v2-preview.

[mattduguid]

Service team plans to release it on May. Maybe azapi provider won't block you.

we have been testing using azapi and have hit a block, we use Customer Managed Keys (CMK) and received this error back from the API, does anyone know if CMK support with PremiumV2_LRS planned as part of the same release?

"error": {
  "code": "CMKBasedEncryptionWithSSDV2NotAllowed",
   "message": "Cannot provision server 'xyz' with data encryption enabled using customer managed keys because it's using storage type 'PremiumV2_LRS'."
}

UPDATE: working now, believe it went GA 31/03

[jaromirmikulik]

Right now, Premium SSD v2 is in GA:
https://techcommunity.microsoft.com/blog/adforpostgresql/premium-ssd-v2-is-now-generally-available-for-azure-database-for-postgresql/4508445