PostgreSQL Server Parameter "log_disconnections" Is Not Enabled

Overview

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.

Vendor

Azure

Cloud Service

PostgreSQL

Related Controls

CIS Azure v2.0.0 4.3.4

References

https://docs.microsoft.com/en-us/rest/api/postgresql/singleserver/configurations/list-by-server, https://docs.microsoft.com/en-us/azure/postgresql/howto-configure-server-parameters-using-portal, https://docs.microsoft.com/en-us/security/benchmark/azure/security-controls-v3-logging-threat-detection#lt-4-enable-logging-for-azure-resources, https://learn.microsoft.com/en-us/powershell/module/az.postgresql/get-azpostgresqlconfiguration?view=azps-9.2.0#example-2-get-specified-postgresql-configuration-by-name, https://learn.microsoft.com/en-us/powershell/module/az.postgresql/update-azpostgresqlconfiguration?view=azps-9.2.0#example-1-update-postgresql-configuration-by-name

Severity

3

Item Types

Microsoft.DBforPostgreSQL.servers.databases