PostgreSQL Monitoring

​

Setup & Configuration

1. Copy the PostgreSQL example configuration file.
   cd /etc/atatus-infra-agent/conf.d/postgresql.d/
   sudo cp postgresql.yml.template postgresql.yml
   
2. Update the file /etc/atatus-infra-agent/conf.d/postgresql.d/postgresql.yml with below configurations.
   # Metrics section
   metrics:
   
     # The host must be passed as PostgreSQL URL. Example:
   - hosts: ["postgres://localhost:5432"]
   
     # Username to use when connecting to PostgreSQL. Empty by default.
     #username: user
   
     # Password to use when connecting to PostgreSQL. Empty by default.
     #password: pass
   
     # Enable database monitoring
     #dbm: true
   
3. Restart the atatus infrastructure agent.
   sudo service atatus-infra-agent restart
   

​

Metrics