PostgreSQL Monitoring

PostgreSQL is a powerful, open source object-relational database system.

Setup & Configuration

The PostgreSQL plugin is included with the Atatus Infra agent by default, please follow the below section to enable.

1. Copy the PostgreSQL example configuration file.

   copy

   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.

   copy

   # 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.

   copy

   sudo service atatus-infra-agent restart
   

Metrics