[Bucardo-general] Bucardo for Daily Dumps of Table Changes?
Greg Sabino Mullane
greg at endpoint.com
Wed May 8 14:58:31 UTC 2013
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:
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 163 bytes
Desc: Digital signature
More information about the Bucardo-general