PostgreSQL Database configuration ‘log_disconnections’ should be on

Description

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.

Remediation Steps

Azure Portal

Azure CLI

  • To enable log_disconnections:

az postgres server configuration set --resource-group <resourceGroupName> --server-name <serverName> --name log_disconnections --value on

Terraform

Example Configuration

resource "azurerm_postgresql_configuration" "example" {
  name  = "log_disconnections"
  value = "on"

  # other required fields here
}