Description:
Enable 'log_retention_days' on 'PostgreSQL Servers'.
Rationale:
Enabling 'log_retention_days' helps PostgreSQL Database to 'Sets 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.
Enabling this setting will enable logs to be retained for the number entered. If this is enabled for 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>