[Bucardo-general] Recover bucardo "hole" in sync

[Greg Sabino Mullane]

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 greg at endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944  45B4 BC9B 9067 1496 4AC8

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170119/807a7110/attachment.sig>