Azure-PostgreSQLServer-Log-Duration-Enabled

Severity: Medium

Description: This control ensures that server parameter "log_duration" is set to "ON" for PostgreSQL Database Server. Enabling log_duration helps the PostgreSQL Database to log the duration of each completed SQL statement 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 update PostgreSQL parameters:

1. Login to Azure Portal using https://portal.azure.com.

2. Go to PostgreSQL server.

3. For each database, click on Server parameters.

4. Search for log_duration.

5. Click ON and save.

Important:

Reference:

• https://docs.microsoft.com/en-us/rest/api/postgresql/configurations/listbyserver