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

[Rosser Schwarz]

On Fri, Jan 6, 2017 at 2:31 AM, Laurent GARCES <laurent.garces at l-rd.fr>
wrote:

> Could someone advice us a safe way to do this?


If I understand your problem correctly, the fix is pretty simple. It sounds
like the data the third host is missing should exist on (at least one of)
the other two, is this correct?

If so, and you can determine which rows are missing on the third host, you
can  "touch" them — where "touching" a row means saying, "UPDATE table SET
id = id WHERE id = ?" or "...WHERE id IN (???)" or "...id BETWEEN ? AND ?"
or whatever — in one of the databases where they *do* exist.

Bucardo will see the row has been modified somehow, and replicate it across
the sync.

That should get you sorted.

If I've not understood your scenario correctly, can you clarify how I was
mistaken?

rls

-- 
:wq
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170107/7db64fe7/attachment.html>