[Bucardo-general] Bucardo-general Digest, Vol 107, Issue 5

[Om Prakash Jaiswal]

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:"bucardo-general-request at bucardo.org" <bucardo-general-request at bucardo.org>
Date:Tue, 13 Sep, 2016 at 5:30 pm
Subject:Bucardo-general Digest, Vol 107, Issue 5

Send Bucardo-general mailing list submissions to
    bucardo-general at bucardo.org

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
    bucardo-general-request at bucardo.org

You can reach the person managing the list at
    bucardo-general-owner at bucardo.org

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]"
    <matthew.d.balman at nasa.gov>
To: "bucardo-general at bucardo.org" <bucardo-general at bucardo.org>
Subject: Re: [Bucardo-general] Bucardo-general Digest, Vol 107, Issue
    1
Message-ID: <D3FC2557.4E5C%matthew.d.balman at nasa.gov>
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 <jbw at hilltopgroup.com>
To: bucardo-general at bucardo.org
Subject: [Bucardo-general] Replication of tables without primary keys
Message-ID: <18544fb1-abc6-d15a-b5db-c1ccbc505d79 at hilltopgroup.com>
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
Bucardo-general at bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general


End of Bucardo-general Digest, Vol 107, Issue 5
***********************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20160913/9bb1b021/attachment-0003.html>