select open change scope Open full search

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

Extensions / Security

pg_audit

An extension for creating audit tables

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packagepg_audit
Version0.1.3
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars10
Latest commit2014-02-18
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

pgmementoTransaction-based audit trail with schema versioning
pgauditprovides auditing functionality
table_logrecord table modification logs and PITR for table/row
recallTracks table changes in per-table _log tables for timestamp-based history queries.
fluxLogs table data changes and reconstructs rows as they existed in the past.
istoriaTable history management with non-linear undo/redo
pg-audit-jsonTrigger-based PostgreSQL table auditing with JSONB row snapshots and recursive change diffs.
supa_auditTrigger-based table audit history with stable UUID record identities and JSONB row versions.

Same project

auditAudits insert, update, and delete operations on PostgreSQL tables.