Description:
Enable 'log_disconnections' on 'PostgreSQL Servers'.
Rationale:
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.
Enabling this setting will enable a log of all disconnections. If this is enabled for a high traffic server, the log may grow exponentially.
From Azure Portal
From Powershell
Use the below command to update 'log_disconnections' configuration.
az postgres server configuration set --resource-group --server-name --name log_disconnections --value on