PostgreSQL Logs Monitoring

The PostgreSQL module collects logs generated by PostgreSQL.

Setup & Configuration

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

1. Add the following lines in the file /etc/atatus-infra-agent/atatus.yml.

   copy

   logs_enabled: true
   

2. Copy the PostgreSQL example configuration file.

   copy

   cd /etc/atatus-infra-agent/conf.d/postgresql.d/
   sudo cp postgresql.yml.template postgresql.yml
   

3. Update the file /etc/atatus-infra-agent/conf.d/postgresql.d/postgresql.yml with below configurations.

   copy

   # Log section
   logs:
   
     # - type : (mandatory) type of log input source (log)
   
     - type: log
   

   copy

   # If you have custom postgres log path, you can use below syntax
   
     # - type: (mandatory) type of log input source (log)
     #   paths: (mandatory) Set paths if type is file
     #   service: (mandatory) name of the service owning the log
     #   source: (mandatory) attribute that defines which integration is sending the log
   
   # Log section
   logs:
      - type: log
        paths:
           - /var/log/postgresql/postgresql-*-*.log*
        source: postgres
        service: postgres
   

4. Restart the atatus infrastructure agent.

   copy

   sudo service atatus-infra-agent restart