Azure_DBPostgreSQL_7 - Cloudlytics

Azure_DBPostgreSQL_7

Ensure server parameter ' log_retention_days is greater than 3 days for PostgreSQL Database Server

Description

Enable log_retention_days on PostgreSQL Servers.

Remediation

Perform the following in the Azure Console:

Login to Azure Portal using https://portal.azure.com
Go to Azure Database for PostgreSQL server
For each database, click on Server parameters
Search for log_retention_days.
Enter value in range 4-7 (inclusive) and save.

Perform the following in Azure Command Line Interface 2.0:

Use the below command to update log_retention_days configuration.

az postgres server configuration set –resource-group <resourceGroupName> –server-name <serverName> –name log_retention_days –value <4-7>

Service

Database Services

Severity

Medium

Compliance

Mapping