pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedData audit trail techniques in postgresql
6+ messages / 3 participants
[nested] [flat]
* Data audit trail techniques in postgresql
@ 2009-08-27 16:28 Nathaniel Smith <nate@summersault.com>
0 siblings, 1 reply; 6+ messages in thread
From: Nathaniel Smith @ 2009-08-27 16:28 UTC (permalink / raw)
To: pgsql-general@postgresql.org; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Data audit trail techniques in postgresql
@ 2009-08-27 17:36 Alvaro Herrera <alvherre@commandprompt.com>
parent: Nathaniel Smith <nate@summersault.com>
0 siblings, 1 reply; 6+ messages in thread
From: Alvaro Herrera @ 2009-08-27 17:36 UTC (permalink / raw)
To: Nathaniel Smith <nate@summersault.com>; +Cc: pgsql-general@postgresql.org; pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [SQL] Data audit trail techniques in postgresql
@ 2009-08-27 18:31 Rob Sargent <robjsargent@gmail.com>
parent: Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 6+ messages in thread
From: Rob Sargent @ 2009-08-27 18:31 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: Nathaniel Smith <nate@summersault.com>; pgsql-general@postgresql.org; pgsql-sql
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.
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [SQL] Data audit trail techniques in postgresql
@ 2009-08-27 19:32 Alvaro Herrera <alvherre@commandprompt.com>
parent: Rob Sargent <robjsargent@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Alvaro Herrera @ 2009-08-27 19:32 UTC (permalink / raw)
To: Rob Sargent <robjsargent@gmail.com>; +Cc: Nathaniel Smith <nate@summersault.com>; pgsql-general@postgresql.org; pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [SQL] Data audit trail techniques in postgresql
@ 2009-08-27 20:30 Rob Sargent <robjsargent@gmail.com>
parent: Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 6+ messages in thread
From: Rob Sargent @ 2009-08-27 20:30 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: Nathaniel Smith <nate@summersault.com>; pgsql-general@postgresql.org; pgsql-sql
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Data audit trail techniques in postgresql
@ 2009-08-28 14:39 Nathaniel Smith <nate@summersault.com>
parent: Rob Sargent <robjsargent@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Nathaniel Smith @ 2009-08-28 14:39 UTC (permalink / raw)
To: pgsql-sql; +Cc: pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2009-08-28 14:39 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-08-27 16:28 Data audit trail techniques in postgresql Nathaniel Smith <nate@summersault.com>
2009-08-27 17:36 ` Alvaro Herrera <alvherre@commandprompt.com>
2009-08-27 18:31 ` Rob Sargent <robjsargent@gmail.com>
2009-08-27 19:32 ` Alvaro Herrera <alvherre@commandprompt.com>
2009-08-27 20:30 ` Rob Sargent <robjsargent@gmail.com>
2009-08-28 14:39 ` Nathaniel Smith <nate@summersault.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox