PGXN

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