How To Install pgaudit on Fedora 34
Introduction
In this tutorial we learn how to install pgaudit on Fedora 34.
What is pgaudit
The PostgreSQL Audit extension (pgaudit) provides detailed session and/or object audit logging via the standard PostgreSQL logging facility. The goal of the PostgreSQL Audit extension (pgaudit) is to provide PostgreSQL users with capability to produce audit logs often required to comply with government, financial, or ISO certifications. An audit is an official inspection of an individual’s or organization’s accounts, typically by an independent body. The information gathered by the PostgreSQL Audit extension (pgaudit) is properly called an audit trail or audit log. The term audit log is used in this documentation.
We can use yum or dnf to install pgaudit on Fedora 34. In this tutorial we discuss both methods but you only need to choose one of method to install pgaudit.
Install pgaudit on Fedora 34 Using dnf
Update yum database with dnf using the following command.
sudo dnf makecache --refresh
The output should look something like this:
Fedora 34 - x86_64 20 kB/s | 6.6 kB 00:00
Fedora 34 openh264 (From Cisco) - x86_64 1.4 kB/s | 989 B 00:00
Fedora Modular 34 - x86_64 68 kB/s | 6.5 kB 00:00
Fedora 34 - x86_64 - Updates 3.5 kB/s | 6.2 kB 00:01
Fedora Modular 34 - x86_64 - Updates 17 kB/s | 5.9 kB 00:00
Metadata cache created.
After updating yum database, We can install pgaudit using dnf by running the following command:
sudo dnf -y install pgaudit
Install pgaudit on Fedora 34 Using yum
Update yum database with yum using the following command.
sudo yum makecache --refresh
The output should look something like this:
Fedora 34 - x86_64 20 kB/s | 6.6 kB 00:00
Fedora 34 openh264 (From Cisco) - x86_64 1.4 kB/s | 989 B 00:00
Fedora Modular 34 - x86_64 68 kB/s | 6.5 kB 00:00
Fedora 34 - x86_64 - Updates 3.5 kB/s | 6.2 kB 00:01
Fedora Modular 34 - x86_64 - Updates 17 kB/s | 5.9 kB 00:00
Metadata cache created.
After updating yum database, We can install pgaudit using yum by running the following command:
sudo yum -y install pgaudit
How To Uninstall pgaudit on Fedora 34
To uninstall only the pgaudit package we can use the following command:
sudo dnf remove pgaudit
pgaudit Package Contents on Fedora 34
/usr/lib/.build-id
/usr/lib/.build-id/0e
/usr/lib/.build-id/0e/712014076a36e17dbb85c3dfe4155f889a0ef6
/usr/lib64/pgsql/pgaudit.so
/usr/share/doc/pgaudit
/usr/share/doc/pgaudit/README.md
/usr/share/licenses/pgaudit
/usr/share/licenses/pgaudit/LICENSE
/usr/share/pgsql/extension/pgaudit--1.5.sql
/usr/share/pgsql/extension/pgaudit.control
/usr/lib/.build-id
/usr/lib/.build-id/eb
/usr/lib/.build-id/eb/f3497dd626ba27ca74c2346f8690d6e2818754
/usr/lib64/pgsql/bitcode/pgaudit.index.bc
/usr/lib64/pgsql/bitcode/pgaudit/pgaudit.bc
/usr/lib64/pgsql/pgaudit.so
/usr/share/doc/pgaudit
/usr/share/doc/pgaudit/README.md
/usr/share/licenses/pgaudit
/usr/share/licenses/pgaudit/LICENSE
/usr/share/pgsql/extension/pgaudit--1.5.sql
/usr/share/pgsql/extension/pgaudit.control
References
Summary
In this tutorial we learn how to install pgaudit on Fedora 34 using yum and dnf.