On Thu, Dec 17, 2015 at 04:09:17AM +0000, Jay Lee wrote: ... > Because data changes are irregular, I cannot rely on the last good time > from the status command, since it may vary from minutes (during busy > work days) to days (weekends). Ideally, I would check the last good > time only if there are changes to replicate. > > What tables should I query for such information? Or alternatively, > does a solution already exist for PRTG?
I have not heard of anyone using PRTG with it. As far as monitoring syncs, your best bet may be to simply scan the delta tables[1] for old entries. If they are old, it likely means a sync is failing. It's possible for delta records to exist after the sync is finished, as the asynchronous VAC process is responsible for cleaning that up, but in a normally-running Bucardo, that window should be small. Another way would be to issue a kick on the syncs to monitor, and see what gets returned (or just check the status once it finishes). A sync with no rows to replicate will still show up as completed. [1] See bucardo.bucardo_delta_names table -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: PGP signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
