PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Assume that we have a PostgreSQL server named pgha1. Follow these steps on the server to enable basic monitoring:

1. Create a file named pgha1.conf in /etc/telegraf/telegraf.d and use the following contents:

[[inputs.postgresql]] 
  address = "host=pgha1 user=postgres" 
  outputaddress = "pgha1" 
  max_lifetime = "0s" 
  databases = ["pgbench"] 

2. Modify the /etc/telegraf/telegraf.conf file and add these two lines near the end:

[[outputs.file]] 
files = ["/tmp/metrics.out"] 

3. Then, restart the telegraf service:

sudo systemctl restart telegraf

4. Watch the /tmp/metrics.out file to see what Telegraf is doing:

tail -f /tmp/metrics.out | grep postgres