PostgreSQL Flexible Server should have high availability enabled

Applies to

• Microsoft.DBforPostgreSQL/flexibleServers

What CGPulse checks

A resource passes this rule when highAvailability.mode must equal ZoneRedundant. Anything else is reported as a finding with the evaluated property value attached as evidence.

How to fix it

Configure zone-redundant high availability to protect against zone failures. In Azure Portal: PostgreSQL Flexible Server > High availability > enable Zone redundant. See: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-high-availability

CLI

az postgres flexible-server update --ids "{id}" --high-availability-mode ZoneRedundant

Bicep

resource pg 'Microsoft.DBforPostgreSQL/flexibleServers@2023-12-01-preview' existing = {{
  name: '{name}'
}}
// TODO: Update highAvailability.mode to 'ZoneRedundant'
// Note: This may require a specific tier (GeneralPurpose or MemoryOptimized)

Terraform

resource "azurerm_postgresql_flexible_server" "{name}" {
  name                = "{name}"
  resource_group_name = "{rg}"
  location            = var.location
  sku_name            = "GP_Standard_D2s_v3"
  version             = "15"
  high_availability {
    mode = "ZoneRedundant"
  }
}

Compliance frameworks

• Cloud Security BaselineBR-1

Related Azure rules

• Action Group should be enabled
• Activity Log Alert should be enabled
• AKS cluster logs should be sent to Log Analytics
• AKS cluster must enable RBAC
• AKS cluster must enable RBAC
• AKS cluster should be a private cluster
• AKS cluster should disable local accounts
• AKS cluster should enable Azure RBAC for Kubernetes