[Bucardo-general] Install Bucardo on Amazon RDS PostgreSQL

[caleb ayodele]

Hi David,


I followed the instructions from the below websites.

http://saifulmuhajir.web.id/postgresql-amazon-rds-as-a-master-how-to-replicate-from-aws/

https://www.endpoint.com/blog/2017/06/06/amazon-aws-upgrades-to-postgres-with

https://bucardo.org/Bucardo/Installation/

On Mon, Jan 15, 2018 at 11:14 AM, David Christensen <david at endpoint.com>
wrote:

> 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>
> 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> wrote:
>>
>> 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. 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>
>> To: bucardo-general at bucardo.org
>> Subject: [Bucardo-general] Install Bucardo on Amazon RDS PostgreSQL
>> Message-ID: <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
>> 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
>> 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 <(785)%20727-1171>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180115/d114391f/attachment-0001.html>