Azure-PostgreSQLServer-Enable-Geo-Redundant-Backups

Owned by naveen
Dec 06, 2021
1 min read

Severity: Medium

Description: This control ensures that PostgreSQL servers are geo redundant backup enabled. Enabling log retention helps PostgreSQL Database to set the number of days a log file is retained which in turn generates query and error logs. Query and error logs can be used to identify, troubleshoot, and repair configuration errors and sub-optimal performance.

Remediation Steps:

Perform following to to create PostgreSQL server with geo-redundant-backup from Azure CLI:

  1. az postgres server create -l -g -n -u -p --sku-name --geo-redundant-backup Enabled.

Important:

  • Geo redundant backups setting can only be setup at the time of creation.

Reference:

Blue Hexagon Proprietary