Control: Azure > CIS v3.0 > 05 - Database Services > 05.02 - Azure Database for PostgreSQL > 05.02.04 - Ensure server parameter 'logfiles.retention_days' is greater than 3 days for PostgreSQL flexible server

Configures auditing against a CIS Benchmark item.

Level: 1

Ensure logfiles.retention_days on PostgreSQL flexible servers is set to an appropriate value.

Configuring logfiles.retention_days determines the duration in days that Azure Database for PostgreSQL retains log files. Query and error logs can be used to identify, troubleshoot, and repair configuration errors and sub-optimal performance.

Resource Types

This control targets the following resource types:

Azure > PostgreSQL > Flexible Server

In Your Workspace

Developers

Control Type URI

tmod:@turbot/azure-cisv3-0#/control/types/r050204

Category URI

tmod:@turbot/cis#/control/categories/v070604

GraphQL

query controlType(id: "tmod:@turbot/azure-cisv3-0#/control/types/r050204") { … }

query controls(filter: "controlTypeId:'tmod:@turbot/azure-cisv3-0#/control/types/r050204'") { … }

CLI

Get Controls

turbot graphql controls --filter "controlTypeId:tmod:@turbot/azure-cisv3-0#/control/types/r050204"