select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Security

pgaudit

provides auditing functionality

pgext.cloud · Source code · Website · License text · Control file · PGXN

Overview

Packagepgaudit
Version18.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPGDG
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariespgaudit
Stars1,697
Latest commit2026-07-30
Latest release2026-07-30
Catalogue updated2026-08-30

Related extensions

See also

pgauditlogtofilepgAudit addon to redirect audit log to an independent file
pg_auditorAudit data changes and provide flashback ability
pg_roastOpinionated PostgreSQL database auditor
pgmementoTransaction-based audit trail with schema versioning
table_logrecord table modification logs and PITR for table/row
pg_drop_eventslogs transaction ids of drop table, drop column, drop materialized view statements
pgelogExtended logging via pseudo-autonomous transactions
logerrorsFunction for collecting statistics about messages in logfile
pg_stat_logTrack cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.
pg_auth_monmonitor connection attempts per user
data_historizationPLPGSQL Script to historize data in partitionned table
table_versionPostgreSQL table versioning extension