[Bucardo-general] Bucardo add tables fails in postgres 10

[Michael Shaich]

Hi,

Not sure if you received my first email or saw the subject and thought oh boy another dude with no primary keys :)

But that's not my issue.  Were stuck with our roll out to post 10 until we understand if this is an isolated issue or if there are other issues migrating to 10.

Any thoughts?

Thanks,


Michael Shaich
Vice-President
Averetek, Inc.<http://www.averetek.com/>
Main: (425) 487-6121 x 101
Direct: (206) 973-3035



From: Michael Shaich
Sent: Friday, November 17, 2017 11:49 AM
To: bucardo-general at bucardo.org
Subject: No primary keys


Hi,



We have Bucardo running on Ubuntu 16.04 and postgres 9.5 & 9.6.  We are attempting to spin up new Ubuntu servers with 16.04 and postgres 10.  We have successfully upgraded the postgres cluster but we are stuck getting bucardo deployed on our new servers.





The command "$ sudo bucardo add all tables db=nynaeve --herd sandy_primary_tables -T agr_activity_sme -T agr_events_all -T agr_events_le -T agr_executions_le -T agr_executions_sme -T agr_initiative_audit -T agr_initiativehits -T agr_link_initiative_activity_audit -T agr_master_activity -T agr_orders_le -T agr_orders_sme -T agr_partners_all -T agr_partners_le -T agr_partners_sme -T agr_resource_audit --verbose"



runs without errors but we get no primary keys.



[cid:image001.png at 01D35F9A.115B6140]







What's our next step to resolve the missing values?  Weve dumped all Bucardo data and rerun the setup but we end up with the same missing data.





Thanks,



Michael Shaich
Vice-President
Averetek, Inc.<http://www.averetek.com/>
Main: (425) 487-6121 x 101
Direct: (206) 973-3035

Bucardo version 5.4.1
Postgres 10.0.1
Ubuntu 16.04



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20171127/e60a84ea/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 25016 bytes
Desc: image001.png
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20171127/e60a84ea/attachment-0001.png>