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

[Jonathan Brinkman]

Greetings

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.

 

[CODE]

for i in alarm.alarm_events alarm.alarm_zonecodes
alarm.admin_applicationsettings_alarm;

do 

    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
db=cmsvog_alarm

done

bucardo_ctl add table alarm.alarm_events_archive herd=cmsvog_alarm_to_main
db=cmsvog_alarm

[/CODE]

 

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!

Jonathan

 

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