[Bucardo-general] Bucardo for Daily Dumps of Table Changes?

[Greg Sabino Mullane]

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 greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130508/4a0b7a2a/attachment.sig>