v0.1 (2014-12-14)

  • Generic audit trail for PostgreSQL 9.3 using the JSON type
  • Log only deltas to recent state
  • Retore previous table and database states
  • Moved from github.com/FxKu/audit

v0.2 (2015-06-12)

  • A new table to store table events of one transaction
  • Switch to JSONB (requires PostgreSQL 9.4)
  • One global audit_id sequence
  • Revert single transactions

v0.3 (2016-05-03)

  • DDL log support: New tables audit_table_log and audit_column_log
  • Restore based on DDL log tables and not manually created templates
  • Revert a range of transactions
  • New install and management scripts

v0.4 (2017-04-11)

  • Event triggers will log data before a DDL event changes it
  • New audit_tables_dependency view to support reverts of transactions with cascading effects
  • Browse past tuple versions without recreating it as a table
  • Supports now PostgreSQL 9.5+

v0.5 (2017-08-09)

  • Revert support for DDL changes
  • Revert functions considering mutually exclusive events during one transaction
  • Catching DDL events that wereexecuted from within functions with GET DIAGNOSTICS
  • Correct logging of data types with typmod definitions in audit_column_log

v0.6 (2018-11-22)

  • Base audit trail on ID sequence of transaction_log instead of internal txid values
  • Re-designed restore API to query historic versions of tuples on-the-fly more easily
  • Allow for logging client-side parameters for each transaction
  • Improved reverts for ADD COLUMN, ALTER COLUMN, RENAME TABLE/COLUMN events and composite data types
  • Added test routines and moved docs to GitHub wiki

v0.6.1 (2019-03-23)

  • Added support for quoted schemas, tables and columns
  • Catching also column constraint changes with ALTER COLUMN events
  • More robust parsing of DDL queries which can now also contain comments
  • Improved audit views listing tables with different OIDs than in audit_table_log

v0.7.0 (2020-05-05)

  • Provide a pgMemento Postgres Extension (by Serge Latyntsev)
  • More fine-grained event logging with statement timestamps
  • Optionally logging new data in row_log, too
  • New audit_schema_log table to configure default audit_id column name and logging behavior
  • Start auditing also after CREATE TABLE AS and SELECT INTO events
  • Stop relying on OID columns in log tables for recovery
  • New scriptable API to init, start, stop and drop pgMemento for a schema

v0.7.1 (2020-08-03)

  • Log session_user instead of current_user because of SECURITY DEFINER
  • Support restoring JSONB and array values
  • Bugfixes on audit initialization

v0.7.2 (2021-05-01)

  • Fixing restoring NULL values introduced with v0.7.1
  • Fix reverting changes with array values
  • Move from travis CI to GitHub actions

v0.7.3 (2021-12-28)

  • PostgreSQL 14 support - session variables must start with a letter
  • Logging changes from all table events happening at the same statement_timestamp (e.g. with a stored procedure)