PostgreSQL disconnections logging is not enabled

ID

azure_postgresql_log_disconnections

Severity

low

Vendor

Azure

Resource

Logging

Tags

non-reachable

Description

PostgreSQL disconnections logging is not enabled. It is recommended to activate this option to be able to view disconnections that are happened.

For that you must configure the option log_disconnections=On.

Learn more about this topic at Azure PostgreSQL module.

Examples

---
- name: Example playbook
  hosts: localhost
  tasks:
    - name: Update PostgreSQL Server setting
      azure_rm_postgresqlconfiguration:
        resource_group: myResourceGroup
        server_name: myServer2
        name: log_disconnections
        value: Off

Mitigation / Fix

---
- name: Example playbook
  hosts: localhost
  tasks:
    - name: Update PostgreSQL Server setting
      azure_rm_postgresqlconfiguration:
        resource_group: myResourceGroup
        server_name: myServer2
        name: log_disconnections
        value: On