PostgreSQL database 'log_min_messages' flag isn’t set to a valid value

ID

gcp_postgresql_misconfigured_log_messages_flag

Severity

info

Vendor

GCP

Resource

Observability

Tags

reachable

Description

To fix it, you must configure the flag log_min_messages at settings.database_flags with a valid value.

Examples

---
- name: sql_instance
  google.cloud.gcp_sql_instance:
    auth_kind: serviceaccount
    database_version: SQLSERVER_13_1
    name: "{{ resource_name }}-2"
    project: test_project
    region: us-central1
    service_account_file: /tmp/auth.pem
    settings:
      database_flags:
        - name: log_min_messages
          value: debug6
      tier: db-n1-standard-1
    state: present

Mitigation / Fix

---
- name: sql_instance
  google.cloud.gcp_sql_instance:
    auth_kind: serviceaccount
    database_version: SQLSERVER_13_1
    name: '{{ resource_name }}-2'
    project: test_project
    region: us-central1
    service_account_file: /tmp/auth.pem
    settings:
      database_flags:
        - name: log_min_messages
          value: log
      tier: db-n1-standard-1
    state: present