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>"}]'