On Mar 4, 2014, at 2:19 AM, David Janssens <david.j@almacom.co.th> wrote: > Hello, > I would like to log statements that modify a small subset of tables in a databases. > (not all tables, because the log files become too big in that case and I also worry about performance) > I currently use log_statement='mod' but I didn't find a way to limit this to the set of tables I want. > What is the best way to do this? You might want to look at trigger based audit logs. Some example code, and a couple of useful packages: http://www.postgresql.org/docs/current/static/plpgsql-trigger.html#PLPGSQL-TRIGGER-AUDIT-EXAMPLE https://github.com/disqus/pg_audit http://pgfoundry.org/projects/tablelog/ http://jimmyg.org/blog/2007/audit-tables-in-postgresql-with-debian.html http://www.varlena.com/GeneralBits/104.php Cheers, Steve
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных