[Bucardo-general] Procedures for changes to goat or herdmap entries

[Adam Wendt]

This is just my personal experience, so Greg may have better suggestions:

1. Easiest I've found is to stop bucardo, ALTER TABLE on both the master and
the slave, then start bucardo again.

2. I've hacked around this by adding goats to a NEW herd(map) and then
create a NEW sync, then next time I redo my bucardo setup I include new
table in the existing sync.

Adam
Adam Wendt Consulting

On Wed, Apr 9, 2008 at 9:59 AM, Shepard, Ric (DFG) <ric.shepard at alaska.gov>
wrote:

> Is there a recommended, step-by-step method, for getting a sync to work
> correctly after making a change to an included goat or its herdmap?  I'm
> specifically interested in two scenarios, both of which have recently been
> encountered in a  Master/Slave setup:
>
> 1. A new column is added to a table (goat) that is already included in a
> syncing herdmap.
>
> 2. New tables (goats) are added to an existing, syncing herdmap.
>
> In both cases, I managed to get Bucardo to replicate to the Slave but, in
> both cases, it took a bit of "futzing" to achieve success.
>
> Thanks for any help or direction.
>
> -Ric Shepard
>
> --
> Ric Shepard, Analyst/Programmer
> Alaska Department of Fish and Game
> Commercial Fisheries, Westward Region
> 211 Mission Road, Kodiak, AK 99615
> 907-486-1862 <ric.shepard at alaska.gov>
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20080409/8a921ecb/attachment.html