select open change scope Open full search

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

Extensions / Security

pg_auditor

Audit data changes and provide flashback ability

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

Overview

Packagepg_auditor
Version0.2
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
RelocatableNo
Schemaauditor
Stars9
Latest commit2025-02-28
Catalogue updated2026-08-30

Related extensions

Requires

hstoredata type for storing sets of (key, value) pairs

See also

pgauditprovides auditing functionality
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
pg_roastOpinionated PostgreSQL database auditor
pgauditlogtofilepgAudit addon to redirect audit log to an independent file
pgelogExtended logging via pseudo-autonomous transactions
data_historizationPLPGSQL Script to historize data in partitionned table
table_versionPostgreSQL table versioning extension
pg_permissionsview object permissions and compare them with the desired state