Looks like at https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/postgresql_flexible_server_configuration

We could pass a comma separated list

resource "azurerm_postgresql_flexible_server_configuration" "example" {
  name      = "azure.extensions"
  server_id = azurerm_postgresql_flexible_server.example.id
  value     = "CUBE,CITEXT,BTREE_GIST"
}

Hi @Carus11, the deployment issue you are seeing with DaC and Viya 2024.12 could also be related to the breaking change documented here https://github.com/sassoftware/viya4-deployment/releases/tag/7.0.0

For Viya 4 Cadences 2024.06 and later: SharedServices Database Creation Behavior Change

For Viya 4 Cadences 2024.06 and later, the sas-data-server-operator will not automatically create the SharedServices database in an External Postgres database instance during the initial deployment of the SAS Viya platform. Instead, you must manually create the SharedServices database before you start the SAS Viya platform deployment using viya4-deployment Release 7.0.0 or later.

Hi @carus1, given that this is a Viya 2024.12 requirement, the expectation is that all external postgres instances, whether in Azure, AWS or GCP will require similar support regarding encryption. Would you agree that is the case given the SAS doc you linked to above https://go.documentation.sas.com/doc/en/sasadmincdc/v_059/itopssr/p05lfgkwib3zxbn1t6nyihexp12n.htm ?

Yes, its a platform pre-install requirement now. I am unaware if it is a default extension anywhere else, or if it need to be explicitly added.