PostgreSQL connection throttling is not enabled

ID

azure_postgresql_connection_throttling

Severity

low

Vendor

Azure

Resource

Network

Tags

reachable

Description

PostgreSQL connection throttling is not enabled. Enabling connection_throttling allows the PostgreSQL Database to set the verbosity of logged messages. Query and error logs can be used to identify, troubleshoot, repair configuration errors, and address sub-optimal performance issues.

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