https://github.com/munakoiso/logerrors/
logerrors is a PostgreSQL extension for collecting statistics about messages in logfile.
The PostgreSQL RPM repository uses PostgreSQL version numbers in the RPM packages. For example logerrors for PostgreSQL 17 is named as logerrors_17. Similarly logerrors for PostgreSQL 15 is named as logerrors_15.
logerrors provides the following subpackages:
Install PGDG repository from: https://yum.postgresql.org/repopackages/
| OS | Command |
|---|---|
| RHEL / Rocky Linux / AlmaLinux / Fedora | dnf install logerrors_17 (or change the version as described above) |
logerrors requires to be added to shared_preload_libraries
before creating the extension. This requires a restart of the PostgreSQL
instance to take effect. If there are additional libraries, please be sure
to add them as a comma-separated list. An example is:
shared_preload_libraries="logerrors"
You can create the extension after restarting the instance. Connect to the database that
you want to create the extension as superuser and run:
CREATE EXTENSION logerrors;
| PostgreSQL version(s) | OS version | Arch | Status |
|---|---|---|---|
| 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 9 | x86_64, aarch64 | Available |
| 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 8 | x86_64, aarch64 | Available |
| 17,16,15,14,13 | Fedora Linux | x86_64 | Available |