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

CLI Remediation Steps

  • To enable log_disconnections:

az postgres server configuration set --resource-group <resourceGroupName> --server-name <serverName> --name log_disconnections --value on