CyanAudit

This Release
CyanAudit 1.0.1
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
The PostgreSQL License
Resources
Special Files
Tags

Extensions

cyanaudit 1.0.1
Cyan Audit core extension

Documentation

cyanaudit_changelog
cyanaudit_changelog
cyanaudit_upgrade_howto
Upgrading Cyan Audit

README

Contents

Cyan Audit

Cyan Audit is a PostgreSQL extension 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.3 and newer.
  • has been production tested for 4 years.

For installation and usage instructions please see doc/cyanaudit.md.