Description:
Ensure 'log_retention_days' on 'PostgreSQL Servers' is set to an appropriate value.
Rationale:
Configuring 'log_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.
Configuring this setting will result in logs being retained for the specified number of days. If this is configured on a high traffic server, the log may grow quickly to occupy a large amount of disk space. In this case you may want to set this to a lower number.
From Azure Portal
From Azure CLI
Use the below command to update 'log_retention_days' configuration.
az postgres server configuration set --resource-group --server-name --name log_retention_days --value <4-7>
From Powershell
Use the below command to update 'log_retention_days' configuration.
Update-AzPostgreSqlConfiguration -ResourceGroupName -ServerName -Name log_retention_days -Value <4-7>