Thread: Postgres auditing features
| Hi Does postgresql have any build-in auditing features like in Oracle's total-recall or fine grained auditing
http://www.oracle.com/technology/products/database/oracle11g/pdf/total-recall-datasheet.pdf http://www.oracle.com/technology/deploy/security/database-security/fine-grained-auditing/index.html
|
On Thu, 11 Jun 2009, SHARMILA JOTHIRAJAH wrote: > Does postgresql have any build-in auditing features like in Oracle's total-recall or fine grained auditing There's nothing built-in, but it's not too difficult to build such facilities yourself. I'm quite sure you could find someone who would be hapy to build you a very extensive implementation of such a feature customized for your application for less than an Oracle license costs. 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.html -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
Greg Smith wrote: > On Thu, 11 Jun 2009, SHARMILA JOTHIRAJAH wrote: > >> Does postgresql have any build-in auditing features like in Oracle's total-recall or fine grained auditing > > There's nothing built-in, but it's not too difficult to build such > facilities yourself. I have added this to the FAQ http://wiki.postgresql.org/wiki/FAQ#Is_there_a_way_to_leave_an_audit_trail_of_database_operations.3F ... he says, hoping that it'll help generate interest in getting the FAQ updated ... -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.