0.1 -> 0.2
- fn_update_audit_log_trigger_on_table()
- Config tables tb_audit_field and tb_audit_data_type
0.2 -> 0.3
- Lots of fixes for pg_dump/pg_restore and schema qualification
- Added sequences sq_pk_audit_field and sq_pk_audit_data_type as config data
0.3 -> 0.4
- Changed extension name to "cyanaudit" and fixed branding throughout.
- Added check for PostgreSQL 9.1.7
- Added support for archiving and restoring audit data to/from files.
- Better error checking throughout and during installation.
- Moved log rotation function to an external Perl script to avoid race condition
- Fixed bug with audit_event sequence going out of range
- Added DDL trigger for Postgres 9.3 and above
0.4 -> 0.9.0
- Made Cyan Audit ready for PGXN
- Changed to semantic version number
0.9.0 -> 0.9.1
- Do not install event trigger on PostgreSQL 9.3.2 or below, as it is not
handled properly by pg_dump.
0.9.1 -> 0.9.2
- Fixed cyanaudit_log_rotate.pl to correctly move archived table to
archive_tablespace and create new table in pg_default tablespace.
- Fixed two functions that were being created in public schema instead of
extensions's schema.
- Configuration parameters are now stored on the database instead of in
postgresql.conf. After upgrade, you may remove the cyanaudit.* config
parameters from postgresql.conf. However, for PostgreSQL 9.1, you must retain
the
custom_variable_classes = cyanaudit
setting.
0.9.2 -> 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 ##.