pgMemento is an innovative auditing extension for PostgreSQL that provides a comprehensive audit trail of data changes and schema modifications using PL/pgSQL triggers and functions. It efficiently logs only the deltas of changes in a JSONB format, allowing for easy tracking and restoration of past data states, making it ideal for data integrity and compliance needs.
Tracks data changes and schema modifications with detailed audit trails
Logs changes as JSONB deltas for efficient storage and retrieval
Supports schema versioning with dedicated audit logs for tables and columns
Automatically initiates auditing for new tables in initialized schemas
Integrates seamlessly with existing PostgreSQL databases via easy installation