Server parameter 'log_disconnections' should be enabled for PostgreSQL Database Server


Enabling log_disconnections helps PostgreSQL Database to log the 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.


From the console

  1. Log in to Azure Portal.
  2. Go to Azure Database for PostgreSQL server.
  3. For each database, click Server parameters.
  4. Search for log_disconnections.
  5. Click ON and save.