[Bucardo-general] Install Bucardo on Amazon RDS PostgreSQL

[David Christensen]

Hi Caleb,

Can you provide the steps you used to setup/install?

Best,

David

> On Jan 14, 2018, at 2:28 PM, caleb ayodele <ulo23k at gmail.com> wrote:
> 
> Thanks for the quick response. i was able to use your documentation on the installation and was able to start bucardo but i ran into some issues.
> 
> issue #1
> 
> i got this error:
> Last error:              : Failed : DBD::Pg::st execute failed: ERROR:  query string argument of EXECUTE is null CONTEXT:  PL/pgSQL function bucardo.bucardo_delta_check(text,text) line 24 at EXECUTE statement at /usr/local/share/perl5/Bucardo.pm line 3400. Line: 5041 Main DB state: ? Error: none DB auth93 state: 22004 Error: 7 DB auth96 state: ? Error: none  (KID 23032)
> 
> issue #2
> 
> Bucardo is not replicating to the target
> 
> On Sat, Jan 13, 2018 at 7:37 PM, Saiful Muhajir <saifulmuhajir at gmail.com <mailto:saifulmuhajir at gmail.com>> wrote:
> The steps is quite straightforward as documented. The only difference is that you need a standalone bucardo server where you would install Postgres with ability to install bucardo, such as EC2 instances.
> 
> Once bucardo server is ready, add the source and target RDS servers and continue from there as the documents said.
> 
> To summarized:
> - prepare an EC2 instances to install bucardo
> - add both source and target in bucardo server
> - add tables, relgroups, syncs, and start
> 
> 
> On 13 Jan 2018 7:00 pm, <bucardo-general-request at bucardo.org <mailto:bucardo-general-request at bucardo.org>> wrote:
> Send Bucardo-general mailing list submissions to
>         bucardo-general at bucardo.org <mailto:bucardo-general at bucardo.org>
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://mail.endcrypt.com/mailman/listinfo/bucardo-general <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 <mailto:bucardo-general-request at bucardo.org>
> 
> You can reach the person managing the list at
>         bucardo-general-owner at bucardo.org <mailto: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. Install Bucardo on Amazon RDS PostgreSQL (caleb ayodele)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Sat, 13 Jan 2018 01:01:54 -0500
> From: caleb ayodele <ulo23k at gmail.com <mailto:ulo23k at gmail.com>>
> To: bucardo-general at bucardo.org <mailto:bucardo-general at bucardo.org>
> Subject: [Bucardo-general] Install Bucardo on Amazon RDS PostgreSQL
> Message-ID: <53D7880E-6415-4CE3-B6E0-88BDDCA5EC47 at gmail.com <mailto:53D7880E-6415-4CE3-B6E0-88BDDCA5EC47 at gmail.com>>
> Content-Type: text/plain; charset=utf-8
> 
> I want to do a migration from RDS Postgres 9.3 to 9.6 with little down time and I was wondering if it is possible for Bucardo to work on RDS Postgres. If so, please let me know how to install it because I can?t seem to get around the plperlu extension part.
> 
> ------------------------------
> 
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org <mailto:Bucardo-general at bucardo.org>
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general <https://mail.endcrypt.com/mailman/listinfo/bucardo-general>
> 
> 
> End of Bucardo-general Digest, Vol 120, Issue 3
> ***********************************************
> 
> 
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org <mailto:Bucardo-general at bucardo.org>
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general <https://mail.endcrypt.com/mailman/listinfo/bucardo-general>
> 
> 
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general

--
David Christensen
End Point Corporation
david at endpoint.com
785-727-1171



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180115/89875e8c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180115/89875e8c/attachment.sig>