Policy: Azure > CIS v3.0 > 05 - Database Services > 05.02 - Azure Database for PostgreSQL > 05.02.07 - [LEGACY] Ensure server parameter 'log_disconnections' is set to 'ON' for PostgreSQL single server

Configures auditing against a CIS Benchmark item.

Level: 1

Enable log_disconnections on PostgreSQL Servers.

NOTE: This recommendation currently only applies to Single Server, not Flexible Server. See additional information below for details about the planned retirement of Azure PostgreSQL Single Server.

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.

Targets

This policy targets the following resource types:

Primary Policy

This policy is used with the following primary policy:

Azure > CIS v3.0 > 05 - Database Services > 05.02 - Azure Database for PostgreSQL

Policy Specification

Schema Type	`string`
Default	`Per Azure > CIS v3.0 > 05 - Database Services`
Valid Values [YAML]	`Per Azure > CIS v3.0 > 05 - Database Services` `Skip` `Check: Benchmark`

In Your Workspace

Policy Settings by Type report

Developers

Category URI

tmod:@turbot/cis#/control/categories/v070602

Policy Type URI

tmod:@turbot/azure-cisv3-0#/policy/types/r050207

GraphQL

query policyType(id: "tmod:@turbot/azure-cisv3-0#/policy/types/r050207") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/azure-cisv3-0#/policy/types/r050207'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/azure-cisv3-0#/policy/types/r050207'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-cisv3-0#/policy/types/r050207"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-cisv3-0#/policy/types/r050207"