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
    icon/buttons/copy
    logs_enabled: true
    
  2. Copy the PostgreSQL example configuration file.

    copy
    icon/buttons/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
    icon/buttons/copy
    #Log section
    logs:
    
      # - type : (mandatory) type of log input source (log)
    
      - type: log
    
    copy
    icon/buttons/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:
            - /path/to/postgres.log
         source: postgres
         service: postgres
    
  4. Restart the atatus infrastructure agent.

    copy
    icon/buttons/copy
    sudo service atatus-infra-agent restart