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

Azure Resource Manager

{
  "name": "log_disconnections",
  "properties": {
    "value": "on"
  }
}

Example Configuration

{
  "type": "Microsoft.DBforPostgreSQL/servers/configurations",
  "apiVersion": "2017-12-01",
  "name": "log_disconnections",
  "properties": {
    "value": "on"
  }
  # other required fields here
}

Terraform

Example Configuration

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

  # other required fields here
}