On Mon, Jan 16, 2017 at 12:34:37PM +0100, Laurent GARCES wrote: ... > As a side question, could you advice a way to monitor the bucardo job on > postgres? > > During the tests phase we did some things like, on each synced database: > > pg_dump <database> --exclude-schema=bucardo -t <syncedTable1> -t > <syncTable2> | sort | md5sum ...
So you are looking for a list of tables that have changed (via Bucardo) during a certain period of time? Parsing of the log.bucardo file may be an option. Make sure log_level = verbose (or debug if you are brave and have disk space to burn :) and you can grep for entries like this: (13639) [Fri Jan 13 17:38:10.588 2017] #10014 KID (mongo) Rows copied to (postgres) C.public.bucardo_test9: 1 If you can describe what you are looking for in more detail, there may be some different options, but that's the first thing that springs to mind. -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8
signature.asc
Description: PGP signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
