without primary key a table ca n be sync using sync type fullcopy. if table have primary key sync type can be used pushdelta .
Sent from Yahoo Mail odn Android From:"[email protected]" <[email protected]> Date:Tue, 13 Sep, 2016 at 5:30 pm Subject:Bucardo-general Digest, Vol 107, Issue 5 Send Bucardo-general mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://mail.endcrypt.com/mailman/listinfo/bucardo-general or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of Bucardo-general digest..." Today's Topics: 1. Re: Bucardo-general Digest, Vol 107, Issue 1 (Balman, Matthew D. (GSFC-428.0)[Embedded Flight Systems, Inc]) 2. Replication of tables without primary keys (Joseph W) ---------------------------------------------------------------------- Message: 1 Date: Mon, 12 Sep 2016 13:31:35 +0000 From: "Balman, Matthew D. (GSFC-428.0)[Embedded Flight Systems, Inc]" <[email protected]> To: "[email protected]" <[email protected]> Subject: Re: [Bucardo-general] Bucardo-general Digest, Vol 107, Issue 1 Message-ID: <d3fc2557.4e5c%[email protected]> Content-Type: text/plain; charset="iso-8859-1" Hi Saiful, >Commands: >$ bucardo add db bcrdrds1 dbname=bucardotest username=bucardo host= >xxxxxx.master.rds.amazonaws.com port=5432 >$ bucardo add db bcrdrds2 dbname=bucardotest >$ bucardo add table tb_department db=bcrdrds1 --herd=bcrdherd --verbose >$ bucardo add dbgroup bcrdgroup1 bcrdrds1:source bcrdrds2:target >?$ bucardo add sync bcrdsync herd=bcrdherd dbs=bcrdgroup1 1. You need to run ?add db? for each database with full username/password/host information (like you did for bcrdrds1) 2. You need to run ?add table? for each database. 3. I suggest this: "bucardo add sync bcrdsync relgroup=bcrdherd dbs=bcrdgroup1:source,bcrdrds2:target? (and then don?t call ?add dbgroup?) Also make sure the perl bindings (and all other bucardo dependencies) for postgres are installed on each database VM, not just the main machine. Hope that helps. ------------------------------ Message: 2 Date: Mon, 12 Sep 2016 22:07:44 -0400 From: Joseph W <[email protected]> To: [email protected] Subject: [Bucardo-general] Replication of tables without primary keys Message-ID: <[email protected]> Content-Type: text/plain; charset="utf-8" Hi all, I'm attempting to get a redundant Davical installation online (I have a standalone installation my company has been using for several years) and after a lot of searching, Bucardo looked like the best of the master-master postgres replication solutions I could find. Davical, unfortunately, has several tables with no primary key or unique ID; I of course find this out after I've gotten all the way to creating the Bucardo sync between the two devices. The first table it got to without a primary key threw the following message: Failed to add sync: DBD::Pg::st execute failed: ERROR: Table "public.addressbook_address_adr" must specify a primary key! at line 117. at line 30. CONTEXT: PL/Perl function "validate_sync" at /usr/local/bin/bucardo line 4612 Is there anything I've missed so far as making Bucardo replicate those tables, or do I have to look for another solution (and if that's the case, does anyone have a suggestion so far as tools go)? Regards, Joseph -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20160912/69755dde/attachment-0001.html> ------------------------------ _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general End of Bucardo-general Digest, Vol 107, Issue 5 ***********************************************
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
