Cyan Audit 0.9.3 Available

*Synopsis*:

*Cyan Audit *is a PostgreSQL extension for in-database audit logging of the
DML that occurs in your database. It allows for forensics to be performed
on past data modifications, for the purposes of finding who was responsible
for making a particular change, or when exactly it occurred.

*Key Features*:

- Enabling or disabling of logging on a column-by-column basis.
- Correlation of transactions with the application-level userid that
performed them (requires a modification to your application).
- Ability to store years of logs in an efficiently accessible manner.
- Backup and restore of logs to and from compressed files.
- Customizable log retention period with automated archival.
- Support for custom textual descriptions to be attached to any
transaction in a space-efficient manner, allowing the layman to better
understand the logs, or differentiating two similar modifications based on
where they happened in the application code (requires application changes).
- Ability to "undo" any transaction by reversing the recorded changes.

*New in 0.9.3*:

- Fixed error where event trigger threw an exception when running as
unprivileged user.
- Tables restored with cyanaudit_restore.pl are now placed into the
correct tablespace and also altered to be owned by the cyanaudit extension.
- More intelligent naming of tables created by cyanaudit_restore.pl.
Name of table will be taken from filename if it looks reasonable, otherwise
it will be named dynamically according to the last recorded event in the
table.
- Fixed concurrency problem when restoring a cyanaudit-enabled database
with pg_restore -j ##.

*Download & Documentation*

- PGXN Page: http://pgxn.org/dist/cyanaudit/0.9.3/

Thank you!

--
Moshe Jacobson
Manager of Systems Engineering, Nead Werx Inc. <http://www.neadwerx.com>
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

"Quality is not an act, it is a habit." -- Aristotle