CyanAudit: Advanced DML Logging Tool for PostgreSQL
CyanAudit is a powerful PostgreSQL extension designed for comprehensive in-database logging of Data Manipulation Language (DML) activities. It enables users to maintain detailed, searchable logs of changes made to database tables, enhancing data integrity and compliance across applications.
Features
Log DML activities on any table with a primary key, regardless of schema.
Easily search logs through a simple queryable view.
Fine-tune logging capabilities on a column-by-column basis via a user-friendly configuration table.
Attribute each operation to specific application users and add human-readable descriptions.
Backup and restore logs effortlessly using provided Perl scripts.
Automatically rotate and drop old logs while archiving years of data to cost-effective tablespaces.
Revert recorded transactions with a straightforward 'undo' feature.
Built entirely in SQL and PL/pgSQL, ensuring compatibility and ease of maintenance.