pgaudit

Website

https://github.com/pgaudit/pgaudit//

Description

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 the extension documentation.

Package naming convention

In order to support new functionality introduced in each PostgreSQL release, pgAudit maintains a separate branch for each PostgreSQL major version which will be maintained in a manner similar to the PostgreSQL project.

pgAudit versions relate to PostgreSQL major versions as follows:

  • pgAudit v17.X is intended to support PostgreSQL 17
  • pgAudit v16.X is intended to support PostgreSQL 16
  • pgAudit v1.7.X is intended to support PostgreSQL 15
  • pgAudit v1.6.X is intended to support PostgreSQL 14
  • pgAudit v1.5.X is intended to support PostgreSQL 13

Please see the Installation section below for actual package names.

Subpackages

pgaudit provides the following subpackages:

  • llvmjit: Provides just-in-time compilation support for pgaudit

Package specifications and repository requirements

PostgreSQL PGDG RPM repository

Install PGDG repository from: https://yum.postgresql.org/repopackages/

Installation

OS Command
RHEL / Rocky Linux / AlmaLinux / Fedora dnf install pgaudit_17 for PostgreSQL 17
RHEL / Rocky Linux / AlmaLinux / Fedora dnf install pgaudit_16 for PostgreSQL 16
RHEL / Rocky Linux / AlmaLinux / Fedora dnf install pgaudit_17_15 for PostgreSQL 15
RHEL / Rocky Linux / AlmaLinux / Fedora dnf install pgaudit_16_14 for PostgreSQL 14
RHEL / Rocky Linux / AlmaLinux / Fedora dnf install pgaudit_15_13 for PostgreSQL 13

Post-installation

Connect to the database that you want to create the extension as superuser and run:

Available packages

pgaudit version PostgreSQL version(s) OS version Arch Status
17 17 RHEL / Rocky Linux / AlmaLinux 9 x86_64, aarch64 Available
17 17 RHEL / Rocky Linux / AlmaLinux 8 x86_64, aarch64 Available
17 17 Fedora x86_64 Available
16 16 RHEL / Rocky Linux / AlmaLinux 9 x86_64, aarch64 Available
16 16 RHEL / Rocky Linux / AlmaLinux 8 x86_64, aarch64 Available
16 16 Fedora x86_64 Available
1.7 15 RHEL / Rocky Linux / AlmaLinux 9 x86_64, aarch64 Available
1.7 15 RHEL / Rocky Linux / AlmaLinux 8 x86_64, aarch64 Available
1.7 15 Fedora x86_64 Available
1.6 14 RHEL / Rocky Linux / AlmaLinux 9 x86_64, aarch64 Available
1.6 14 RHEL / Rocky Linux / AlmaLinux 8 x86_64, aarch64 Available
1.6 14 Fedora x86_64 Available
1.5 13 RHEL / Rocky Linux / AlmaLinux 9 x86_64, aarch64 Available
1.5 13 RHEL / Rocky Linux / AlmaLinux 8 x86_64, aarch64 Available
1.5 13 Fedora x86_64 Available

News