PostgreSQL Logs Monitoring | Atatus Documentation

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.

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

copy
```
logs_enabled: true
```
Copy the PostgreSQL example configuration file.

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

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

Restart the atatus infrastructure agent.

copy
```
sudo service atatus-infra-agent restart
```