Skip site navigation (1) Skip section navigation (2)

Re: Data audit trail techniques in postgresql

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Nathaniel Smith <nate(at)summersault(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: Data audit trail techniques in postgresql
Date: 2009-08-27 17:36:17
Message-ID: 20090827173617.GK11213@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

In response to

Responses

pgsql-sql by date

Next:From: Rob SargentDate: 2009-08-27 18:31:23
Subject: Re: [SQL] Data audit trail techniques in postgresql
Previous:From: Nathaniel SmithDate: 2009-08-27 16:28:31
Subject: Data audit trail techniques in postgresql

pgsql-general by date

Next:From: BlackMageDate: 2009-08-27 18:09:36
Subject: Select data for current week only
Previous:From: John R PierceDate: 2009-08-27 17:13:30
Subject: Re: Viable alternatives to SQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group