select open change scope Open full search

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

Extensions / Time series

flux

Logs table data changes and reconstructs rows as they existed in the past.

pgext.cloud · Source code · Documentation · Control file

Overview

Packageflux
Version0.3
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schema_flux
Stars2
Latest commit2018-03-27
Catalogue updated2026-08-30

Related extensions

Requires

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

See also

pgmementoTransaction-based audit trail with schema versioning
recallTracks table changes in per-table _log tables for timestamp-based history queries.
table_logrecord table modification logs and PITR for table/row
hstoredata type for storing sets of (key, value) pairs
pg_auditAn extension for creating audit tables
istoriaTable history management with non-linear undo/redo
pgauditprovides auditing functionality
ddlaAudit DDL changes with event triggers and queryable log functions
pg-audit-jsonTrigger-based PostgreSQL table auditing with JSONB row snapshots and recursive change diffs.
pg_dbo_timestampPostgreSQL extension for storing time and author of database structure modification.