From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | table logging |
Date: | 2012-10-28 19:25:33 |
Message-ID: | CAMkU=1xN8jV2YoDz5_NC2_EBcFb31OPq69cQ4fxAkLevY40y1Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
The latter is very flexible, but is rather complex as you have to fish
out the data with queries against hstore object, instead of tables
with the same structure as the tables being logged. On the other hand
it does deal with columns being added to the underlying tables more
gracefully.
Are there widely used/supported options other than these two, and of
course rolling my own?
Cheers,
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Julian | 2012-10-28 23:01:16 | Re: table logging |
Previous Message | Karl Denninger | 2012-10-28 19:08:48 | pg_lesslog - status? |