PostgreSQL Database configuration ‘log_disconnections’ should be on¶
Description¶
Enabling log_disconnections helps PostgreSQL Database to Logs end of a session, including duration, 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.
Portal Remediation Steps¶
Navigate to Azure Database for PostgreSQL servers.
Select the PostgreSQL server.
In the left navigation, select Server parameters.
In
log_disconnections, select ON.Click Save.
CLI Remediation Steps¶
To enable
log_disconnections:
az postgres server configuration set --resource-group <resourceGroupName> --server-name <serverName> --name log_disconnections --value on