select open change scope Open full search

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

Extensions / Time series

emaj

Enables fine-grained write logging and time travel on subsets of the database.

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

Overview

Packageemaj
Version5.0.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemaemaj
Stars92
Latest commit2026-07-24
Latest release2026-07-23
Catalogue updated2026-08-30

Related extensions

Requires

btree_gistsupport for indexing common datatypes in GiST
dblinkconnect to other PostgreSQL databases from within a database

See also

table_versionPostgreSQL table versioning extension
pgmementoTransaction-based audit trail with schema versioning
data_historizationPLPGSQL Script to historize data in partitionned table
table_logrecord table modification logs and PITR for table/row
ddl_historizationHistorize the ddl changes inside PostgreSQL database
periodsProvide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
temporal_tablestemporal tables