[Bucardo-general] debugging KID SQL errors

Bill McGonigle bill at bfccomputing.com
Wed Sep 29 16:10:22 UTC 2010


On 09/27/2010 08:33 PM, Greg Sabino Mullane wrote:
> Just a random stab, but does validate sync return without an error?
>
> $ bucardo_ctl validate<syncname>

Perfect.  'validate' uncovered a few tables that were missing their 
primary keys in the DDL (the 'list tables' format is tremendously useful 
here).  Added them, and things are working as expected now.

Now to check that the other direction (multi-master) works as well (and 
see if my little helper script can prove its mettle...).

Thanks!

-Bill

-- 
Bill McGonigle, Owner
BFC Computing, LLC
http://bfccomputing.com/
Telephone: +1.603.448.4440
Email, IM, VOIP: bill at bfccomputing.com
VCard: http://bfccomputing.com/vcard/bill.vcf
Social networks: bill_mcgonigle/bill.mcgonigle


More information about the Bucardo-general mailing list