Installing pgaudit

pg_audit is supported on the same platforms as the Postgres distribution you're using. Support for pg_audit starts with Postgres 12. For details, see:

• PostgreSQL Product Compatibility
• EDB Postgres Extended Server Product Compatibility

Installation

Before you begin the installation process:

• Install Postgres. See:

  • Installing PostgreSQL

  • Installing EDB Postgres Extended Server

• Set up the repository.

  Setting up the repository is a one-time task. If you've already set up your repository, you don't need to perform this step.

  To set up the repository, go to EDB repositories and follow the instructions provided there.

Install the package

The syntax for the package install command is:

# For SLES, CentOS, RHEL and its derivatives
sudo <package-manager> -y install edb-<postgres><postgres_version>-pg-audit1

# For Debian and Ubuntu
sudo <package-manager> -y install edb-<postgres><postgres_version>-pg-audit-1

Where:

• <package-manager>is the package manager used with your operating system:

  Package manager	Operating system
  dnf	RHEL 8/9 and derivatives
  yum	RHEL 7 and derivatives, CentOS 7
  zypper	SLES
  apt-get	Debian and derivatives

• <postgres> is the distribution of Postgres you're using:

  Postgres distribution	Value
  PostgreSQL	pg
  EDB Postgres Extended Server	postgresextended

• <postgres-version> is the version of Postgres you're using.

For example, to install pg_audit for EDB Postgres 15 on a RHEL 8 platform:

sudo dnf -y install edb-pg15-pg-audit1