[Bucardo-general] bucardo won't add tables to herd

Jonathan Brinkman jb at blackskytech.com
Thu Jun 27 14:07:05 UTC 2013


I'm creating a push-delta using Bucardo 4.5.0 from a remote server to the
master server (Ubuntu 12.04LTS, Postgres 12.2). 


The following code fails to enter any table or sequence names in the herdmap
table. I don't understand why. I have 4 other syncs on these servers, but I
add tables differently to those syncs. The herd does exist already in the
herd table. The goats are in the goat table. The db is used in another sync
(opposite direction, pushdelta, different tables than this problem sync) and
is in the db table.



for i in alarm.alarm_events alarm.alarm_zonecodes


    echo ---------- ${i} --------------

    bucardo_ctl add table $i herd=cmsvog_alarm_to_main db=cmsvog_alarm

    bucardo_ctl add sequence ${i}_seq herd=cmsvog_alarm_to_main


bucardo_ctl add table alarm.alarm_events_archive herd=cmsvog_alarm_to_main



I had to manually add the goats to herdmap using:

INSERT INTO bucardo.herdmap (herd,goat)

                SELECT 'cmsvog_alarm_to_main',id

                FROM bucardo.goat

                WHERE db = 'cmsvog_alarm';


thank you for your advice!



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130627/12d0cc69/attachment.html>

More information about the Bucardo-general mailing list