template.j2

{% if key == "postgresql", _  in process.elk.additions.metricbeat %}
#------------------------------ PostgreSQL Module ------------------------------
- module: postgresql
  enabled: true
  metricsets:
    # Stats about every PostgreSQL database
    - database

    # Stats about the background writer process's activity
    - bgwriter

    # Stats about every PostgreSQL process
    - activity

    #period: 10s
{% for item in process.elk.additions.metricbeat %}
  period: ["{{ item.period }}"]
{% endfor %}


  # The host must be passed as PostgreSQL URL. Example:
  # postgres://localhost:5432?sslmode=disable
  # The available parameters are documented here:
  # https://godoc.org/github.com/lib/pq#hdr-Connection_String_Parameters
{% for item in process.elk.additions.metricbeat %}
  hosts: ["{{ item.hosts }}"]
{% endfor %}

  # Username to use when connecting to PostgreSQL. Empty by default.
  #username: user
{% for item in process.elk.additions.metricbeat %}
  username: ["{{ item.username }}"]
{% endfor %}
  # Password to use when connecting to PostgreSQL. Empty by default.
  #password: pass
{% for item in process.elk.additions.metricbeat %}
  password: ["{{ item.password }}"]
{% endfor %}
{% endif %}