Is there a way to leave an audit trail of database operations?
There’s nothing built-in, but it’s not too difficult to build such facilities yourself. Simple example right in the official docs: http://www.postgresql.org/docs/8.3/static/plpgsql-trigger.html#PLPGSQL-TRIGGER-AUDIT-EXAMPLE Project targeting this feature: http://pgfoundry.org/projects/tablelog/ Background information and other sample implementations: http://it.toolbox.com/blogs/database-soup/simple-data-auditing-19014 http://www.go4expert.com/forums/showthread.php?t=7252 http://www.alberton.info/postgresql_table_audit.
