Control: Geo-redundant backup should be enabled for Azure Database for PostgreSQL

Description

Azure Database for PostgreSQL allows you to choose the redundancy option for your database server. It can be set to a geo-redundant backup storage in which the data is not only stored within the region in which your server is hosted, but is also replicated to a paired region to provide recovery option in case of a region failure. Configuring geo-redundant storage for backup is only allowed during server create.

Usage

Run the control in your terminal:

powerpipe control run terraform_azure_compliance.control.postgres_db_server_geo_redundant_backup_enabled

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run terraform_azure_compliance.control.postgres_db_server_geo_redundant_backup_enabled --share

SQL

This control uses a named query:

select
  address as resource,
  case
    when (attributes_std ->> 'geo_redundant_backup_enabled') is null then 'alarm'
    when (attributes_std ->> 'geo_redundant_backup_enabled')::boolean then 'ok'
    else 'alarm'
  end status,
  split_part(address, '.', 2) || case
    when (attributes_std ->> 'geo_redundant_backup_enabled') is null then ' ''geo_redundant_backup_enabled'' not set'
    when (attributes_std ->> 'geo_redundant_backup_enabled')::boolean then ' Geo-redundant backup enabled'
    else ' Geo-redundant backup disabled'
  end || '.' reason
  
  , path || ':' || start_line
from
  terraform_resource
where
  type = 'azurerm_postgresql_server';

Control: Geo-redundant backup should be enabled for Azure Database for PostgreSQL

Description

Usage

SQL

Tags