On Sat, May 04, 2013 at 08:00:58PM -0700, Kong Man wrote: ... > if it is ever possible to use Bucardo to generate a daily delta dump > (e.g. in tab-delimited format) of a table over a 24-hour period cycle > with an activity column to indicate insert, update, or delete transactions. > Could the customcode feature be the answer to that?
No, that would not be possible - Bucardo doesn't track what action changed a row (insert, update, or delete), but simply marks the row as changed. The best you can do is generate a list of changed rows. There is some support for such a thing in the latest code with the concept of a "flatfile" target database, but if you really need auditing as you are describing, there are better tools for that. Perhaps something like: http://pgfoundry.org/projects/tablelog/ http://jimmyg.org/blog/2007/audit-tables-in-postgresql-with-debian.html -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
