Enable postgres data collection

To enable the agent to collect metrics/logs from postgres, please follow these instructions.

Once postgres is deployed on kubernetes, do the following

kubectl exec -it <pod> bash
psql -U postgres
enter password to complete login

create user datadog with password '<PASSWORD>';
grant pg_monitor to datadog;
grant SELECT ON pg_stat_database to datadog;

Add the following annotations to the postgres pods

      ad.datadoghq.com/mysql.check_names: '["postgres"]'
      ad.datadoghq.com/mysql.init_configs: '[{}]'
      ad.datadoghq.com/mysql.instances: '[{"host": "%%host%%", "port":5432, username": "datadog", "password" : "<password>"}]'

External

Enable postgres data collection

Related pages