[Bucardo-general] Master-Master->slave working?

Greg Sabino Mullane greg at endpoint.com
Tue Jun 22 21:54:04 UTC 2010

> Where aumaster and usmaster are in sync, and backup_server is not...
> To get them in sync I sent the following to the auserver:
> delete from audit where pk = 114761246;
> delete from evid2raw where rawid = 1 and evidid = 1;
> delete from rawevidence where rawid = 1;
> delete from nets2evid where evidid = 1 and netid = 1;
> delete from networks where netid = 1;
> My intention is to re-insert them if the deletion put the DBs back in
> sync.....

Not exactly sure what you mean by "back in sync", but a simple update 
should do the trick as well. In other words:

UPDATE audit SET pk=pk WHERE pk = 11476246;

should kick off Bucardo, sync the row to the other side (usmaster 
in this case), and from there push it on over to the backup_server 
(once the recent fixes to Bucardo.pm are applied and makedelta 
starts working).

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100622/44151c23/attachment.bin 

More information about the Bucardo-general mailing list