Обсуждение: Data audit trail techniques in postgresql
Howdy, (cross-posted to the pg.sql and pg.general lists) I'm looking to set up an audit trail system--ie, logging every INSERT/UPDATE/DELETE on a given table and tracking how the data changes over time. I know I could do it by hand using triggers, but was hoping to save a little time using something prepackaged. I installed and tested the two-year untouched http://pgfoundry.org/projects/audittrail2/ --the only auditing tool on pgFoundry with a release--and found that, while it works well, it's still marked as beta and has an obvious bug in it when used in 8.3.7. What do others use to accomplish this? Do most pg users just write triggers by hand? Or is there some nice auditing module that Google just isn't revealing to me? Thanks. Nathaniel Smith Web Application Developer Summersault, LLC. 710 E. Main St., Suite 200 Richmond, IN 47374 www.summersault.com
Nathaniel Smith wrote: > What do others use to accomplish this? Do most pg users just write > triggers by hand? Or is there some nice auditing module that Google > just isn't revealing to me? I think tablelog (to be found in pgfoundry too) is the most commonly used audit module. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
tablelog doesn't appear any more lively than the OPs audittrail2. Alvaro Herrera wrote: > Nathaniel Smith wrote: > > >> What do others use to accomplish this? Do most pg users just write >> triggers by hand? Or is there some nice auditing module that Google >> just isn't revealing to me? >> > > I think tablelog (to be found in pgfoundry too) is the most commonly > used audit module. > >
Rob Sargent escribió: > tablelog doesn't appear any more lively than the OPs audittrail2. Perhaps, but I have heard of people using it successfully recently, whereas Nathaniel reported that audittrail2 seems to have obvious bugs. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Alvaro Herrera wrote: > Rob Sargent escribió: > >> tablelog doesn't appear any more lively than the OPs audittrail2. >> > > Perhaps, but I have heard of people using it successfully recently, > whereas Nathaniel reported that audittrail2 seems to have obvious bugs. > > Fair enough.
Alvaro Herrera wrote: > Perhaps, but I have heard of people using it successfully recently, > whereas Nathaniel reported that audittrail2 seems to have obvious > bugs. Thanks for the tip. Do to poor searching on my part tablelog fell under my radar. I'll try and out and see how it goes. Nathaniel Smith Web Application Developer Summersault, LLC. 710 E. Main St., Suite 200 Richmond, IN 47374 www.summersault.com