PGXN

PostgreSQL Extension Network

PGXN Gear PostgreSQL Extension Network
  • FxKu
  • pgMemento 0.7.4
  • _Sidebar
  • Users
  • Tags
  • Recent

Contents

      • Home
      • General
      • Setup
      • Schema
      • Logging behaviour
      • Query logs
      • Restore data
      • Revert transactions
      • Manage the audit trail
      • Future development

Home

General

  • How does it work
  • Background
  • Database schema
  • History
  • Media

Setup

  • Requirements
  • Install pgMemento
  • Initialize auditing
  • Pause and restart logging
  • End an audit trail
  • Uninstall pgMemento
  • Upgrade from v0.6 to v0.6.1
  • Upgrade from v0.6.1 to v0.7
  • Upgrade from v0.7 to v0.7.4

Schema

  • Transaction_log
  • Table_event_log
  • Row_log
  • Audit_schema_log
  • Audit_table_log
  • Audit_column_log
  • Audit_tables VIEW
  • Audit_tables_dependency VIEW

Logging behaviour

  • What is logged
  • DML logging
  • DDL logging
  • User-defined session infos

Query logs

  • Search by key
  • Search by key and value
  • Merge JSONB logs

Restore data

  • Thinking in transactions
  • Restore a value
  • Restore a record
  • Restore a recordset (table)
  • Restore multiple versions at once
  • Persist a restored recordset

Revert transactions

  • How reverts work
  • Reverting multiple transactions

Manage the audit trail

  • Delete logs
  • Data corrections

Future development

  • Branching
  • More log tables for database objects
  • Testing
  • Collection of ideas
Blog | Mastodon | Release on PGXN About | FAQ | Mirroring | Feedback