4.3.5 Ensure server parameter 'log_disconnections' is set to 'ON' for PostgreSQL Database Server

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

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

See Also

https://workbench.cisecurity.org/files/3459