PostgreSQL checkpoint logging is not enabled

ID

azure_postgresql_log_checkpoints

Severity

low

Vendor

Azure

Resource

Logging

Tags

non-reachable

Description

PostgreSQL checkpoint logging is not enabled. It is recommended to activate this option to be able to view checkpoints logging.

For that you must configure the option log_checkpoints=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_checkpoints
        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_checkpoints
        value: On