Information
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.
Solution
From Azure Console
Login to Azure Portal using https://portal.azure.com
Go to Azure Database for PostgreSQL server
For each database, click on Server parameters
Search for log_disconnections.
Click ON and save.
Using Azure Command Line Interface 2.0
Use the below command to update log_disconnections configuration.
az postgres server configuration set --resource-group <resourceGroupName> --server-name <serverName> --name log_disconnections --value on