Horton

Re: table logging

Richard Huxton <dev@archonet.com>

View thread View on postgr.es
From: Richard Huxton <dev@archonet.com>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-general@postgresql.org
Date: 2012-10-29T10:03:01Z
Lists: pgsql-general 
On 28/10/12 19:25, Jeff Janes wrote:
> I am looking for some very simple table logging.  I am not trying to
> do auditing in a hostile environment, just simple logging.
>
> I found two candidates, tablelog from pgfoundry, and
> http://wiki.postgresql.org/wiki/Audit_trigger_91plus
>
> The first has the advantage of being simple, but hasn't been
> maintained in 5 years which is a little worrisome.

I've got tablelog in use on one of my projects. I had to make one small 
fix when I upgraded the db to 9.1 - something to do with quote escaping. 
Can't remember the details I'm afraid.

Other than that, it seems to work fine.


-- 
   Richard Huxton
   Archonet Ltd