Datadog Agent for PostgreSQL Logs and Metrics

Kloudfuse can ingest metrics and logs from a self-managed PostgreSQL deployments through the Datadog agent.

Prerequisites

For the collector to scrape data from postgres, follow the steps documented by Datadog to ensure smooth integration between the Datadog Agent and PostgreSQL, Before you begin.

Annotate the PostgreSQL Instance

  1. Add the following podAnnotations to the postgresql.conf file:

    postgresql:
  primary:
    podAnnotations:
      ad.datadoghq.com/postgresql.check_names: '["postgres"]'
      ad.datadoghq.com/postgresql.init_configs: '[{}]'
      ad.datadoghq.com/postgresql.instances: '[{"host": "%%host%%", "port":5432, "username": "<user-you-created>", "password" : "<password-you-chose>", "tags" : []}]'
  readReplicas:
    podAnnotations:
      ad.datadoghq.com/postgresql.check_names: '["postgres"]'
      ad.datadoghq.com/postgresql.init_configs: '[{}]'
      ad.datadoghq.com/postgresql.instances: '[{"host": "%%host%%", "port":5432, "username": "<user-you-created>", "password" : "<password-you-chose>", "tags" : []}]'
    yaml

  2. Restart PostgreSQL instance after saving these changes.