pgMemento: Advanced PostgreSQL Auditing Tool icon

pgMemento: Advanced PostgreSQL Auditing Tool

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.

Features

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

Repository Details

384
41
Updated: 11/14/2024

Languages

PLpgSQL
Shell
Makefile

Topics

postgresql
versioning
audit-trail
plpgsql
transaction-log
jsonb

License

GNU Lesser General Public License v3.0