How To Install pgaudit on Fedora 36

In this tutorial we learn how to install pgaudit in Fedora 36. pgaudit is PostgreSQL Audit Extension

Introduction

In this tutorial we learn how to install pgaudit on Fedora 36.

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 36. In this tutorial we discuss both methods but you only need to choose one of method to install pgaudit.

Install pgaudit on Fedora 36 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

After updating yum database, We can install pgaudit using dnf by running the following command:

sudo dnf -y install pgaudit

Install pgaudit on Fedora 36 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

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 36

To uninstall only the pgaudit package we can use the following command:

sudo dnf remove pgaudit

pgaudit Package Contents on Fedora 36

/usr/lib/.build-id
/usr/lib/.build-id/df
/usr/lib/.build-id/df/ea056923aa75e0974b362a3dcf923b58e6437e
/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.6--1.6.1.sql
/usr/share/pgsql/extension/pgaudit--1.6.1.sql
/usr/share/pgsql/extension/pgaudit.control

References

pgaudit website

Summary

In this tutorial we learn how to install pgaudit on Fedora 36 using yum and [dnf]((/fedora/36/dnf/).