Hi Matthew, I have successfully setup Bucardo multi-masters myself on my own servers. And it was working fine. The next step is, I want to setup replication and use RDS as a master.
To reply your question: - Bucardo version 5.4.1 - PostgreSQL version 9.5.4 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 Once I put some data, I execute: $ bucardo kick bcrdsync No error while performing those commands. The error only appear in the log once kick is fired: KID (bcrdsync) New kid, sync "bcrdsync" alive=1 Parent=31277 PID=31286 kicked=0 KID (bcrdsync) Kid has died, error is: DBD::Pg::st execute failed: ERROR: relation "bucardo.bucardo_truncate_trigger" does not exist LINE 1: ...ident(tname), MAX(EXTRACT(epoch FROM cdate)) FROM bucardo.bu... ^ at /usr/local/share/perl/5.18.2/Bucardo.pm line 3299. Line: 5041 Main DB state: ? Error: none DB bcrdrds2 state: ? Error: none DB bcrdrds3 state: 42P01 Error: 7 KID (bcrdsync) Kid 31286 exiting at cleanup_kid. Sync "bcrdsync" Reason: DBD::Pg::st execute failed: ERROR: relation "bucardo.bucardo_truncate_trigger" does not exist LINE 1: ...ident(tname), MAX(EXTRACT(epoch FROM cdate)) FROM bucardo.bu... ^ at /usr/local/share/perl/5.18.2/Bucardo.pm line 3299. Line: 5041 Main DB state: ? Error: none DB bcrdrds2 state: ? Error: none DB bcrdrds3 state: 42P01 Error: 7 -- On 31 August 2016 at 19:00, <[email protected]> wrote: > 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 106, Issue 5 > (Balman, Matthew D. (GSFC-428.0)[Embedded Flight Systems, Inc]) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 30 Aug 2016 12:18:36 +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 106, Issue > 5 > Message-ID: <d3eaf10a.4d4b%[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > > > >Am I missing something? > > What bucardo version are you using? > Please post the setup commands and output. > What versions of the database(s) are you using? > > I haven?t done what you?re doing, but this seems like the setup itself > didn?t complete properly and hopefully there is an error message point to > what went wrong. > Either that or you have a permissions issue. > For these kinds of things it can be helpful to try this with very > privileged database and local user to see if the problem goes away and > then reduce permissions. > > > > ------------------------------ > > _______________________________________________ > Bucardo-general mailing list > [email protected] > https://mail.endcrypt.com/mailman/listinfo/bucardo-general > > > End of Bucardo-general Digest, Vol 106, Issue 6 > *********************************************** >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
