[Bucardo-general] Standard Recovery Process

[Greg Sabino Mullane]

On Wed, 2007-10-03 at 12:28 -0600, Ben Allen wrote:
> I was wondering what the standard process to recover after one the
> replicated databases fail and requires to be rebuilt in a
> master-master setup.
> 
> 
> Would setting the database and schema up, then recreating the entry in
> the sync table work? Would Bucardo then replicate everything in the
> live database to the rebuilt database?

No, you would need to "touch" every row in each table to force that to
happen (and make sure that the standard_conflict was "source"). Which
would be very costly. A better way would be to create a fullcopy sync
from the good to the rebuilt, and then kick that sync off one-time to
populate the tables on the second database. And then disable that sync,
for safety reasons.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation 610-983-9073

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 155 bytes
Desc: This is a digitally signed message part
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20071003/2e23db48/attachment.bin