select open change scope Open full search

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

Extensions / Security

pgmemento

Transaction-based audit trail with schema versioning

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

Overview

Packagepgmemento
Version0.7.4
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeSQL only
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemapgmemento
Stars411
Latest commit2026-04-27
Latest release2022-10-31
Catalogue updated2026-08-30

Related extensions

See also

table_logrecord table modification logs and PITR for table/row
pgauditprovides auditing functionality
table_versionPostgreSQL table versioning extension
data_historizationPLPGSQL Script to historize data in partitionned table
ddl_historizationHistorize the ddl changes inside PostgreSQL database
pg_drop_eventslogs transaction ids of drop table, drop column, drop materialized view statements
periodsProvide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
temporal_tablestemporal tables
emajEnables fine-grained write logging and time travel on subsets of the database.
pgelogExtended logging via pseudo-autonomous transactions