[Bucardo-general] adding a column
Bill McGonigle
bill at bfccomputing.com
Mon Nov 1 21:59:24 UTC 2010
Hi, everybody,
We added a column to a table bucardo is replicating today and had an
interesting find. Figured I'd share for group knowledge and/or
We added the column to both databases (multi-master) and added data to
the _left side. At this point we did not see replication.
After a bit of experimentation, we did an UPDATE on the table to a
different column, and then that value and the value in the new column
replicated successfully. Now, the replication succeeds with all
UPDATE's, even on only the new column.
Based on this, after adding a column, doing:
UPDATE foo_bar SET row_id=row_id;
seems like something we ought to add to our SOP for adding a column.
I'm supposing that bucardo figures out the triggers aren't right on the
new column and fixes that. Sound right? I see we have documentation
for adding a table but I didn't see adding a column advice in the wiki.
I'd be happy to add it if this makes sense.
-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