CyanAudit
- This Release
- CyanAudit 2.2.0
- Date
- Status
- Stable
- Latest Testing
- CyanAudit 0.9.5 —
- Other Releases
- Abstract
- DML logging tool for PostgreSQL
- Description
- Cyan Audit provides in-database logging of all DML activity on a column-by-column basis
- Released By
- jehsom
- License
- PostgreSQL
- Resources
- Special Files
- Tags
Extensions
- cyanaudit 2.2.0
- Cyan Audit core extension
Documentation
- CHANGELOG
- CHANGELOG
- cyanaudit_upgrade_howto
- Upgrading Cyan Audit
README
Contents
Cyan Audit
Cyan Audit is a PostgreSQL utility providing comprehensive and easily-searchable logs of DML (INSERT/UPDATE/DELETE) activity in your database.
With Cyan Audit you can:
- Log any table with a PK, regardless of schema.
- Search logs by querying a simple view.
- Toggle logging on a column-by-column basis using an easy config table.
- Attribute every operation to a specific application user.
- Label any operation with a human-readable description.
- Back up and restore logs with confidence using supplied Perl scripts.
- Rotate & drop old logs automatically using a supplied Perl script.
- Keep years of logs online comfortably with automatic archival to your cheap tablespace.
- Effectively "undo" any recorded transaction by playing its operations in reverse.
- Save time with a design focused on ease of setup and maintenance.
Cyan Audit:
- is written entirely in SQL and PL/pgSQL (except Perl cron scripts).
- is Trigger-based.
- supports PostgreSQL 9.6 and newer.
- has been production tested since 2012.
For installation and usage instructions please see doc/cyanaudit.md.