[Bucardo-general] Install Bucardo on Amazon RDS PostgreSQL

Mon Jan 15 17:17:39 UTC 2018

i installed burcado on a separated EC2 instance with postgres9.6

i created a bucardo database in the postgres instance

the bucardo install created a bucardo user and created several tables

i dumped the source database into the target

i created the source/target database with bucardo and also create a herd

i added all the tables and sequences to the herd

i created a sync and started bucardo

This is what i saw in the logs:

24176) [Sun Jan 14 21:37:38 2018] KID (auth_migrate) Kid has died, error
is: 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
(24176) [Sun Jan 14 21:37:38 2018] KID (auth_migrate) Kid 24176 exiting at
cleanup_kid. Sync "auth_migrate" public.activation_token_id_seq Reason:
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
(24150) [Sun Jan 14 21:37:38 2018] MCP Starting check_sync_health
(24179) [Sun Jan 14 21:37:49 2018] KID (auth_migrate) New kid, sync
"auth_migrate" alive=1 Parent=24154 PID=24179 kicked=1
(24179) [Sun Jan 14 21:37:50 2018] KID (auth_migrate) Kid has died, error
is: 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
(24179) [Sun Jan 14 21:37:50 2018] KID (auth_migrate) Kid 24179 exiting at
cleanup_kid. Sync "auth_migrate" public.activation_token_id_seq Reason:
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

I think it might have something to do with a fucntion called
*bucardo_delta_check(text,text)* but i looked for the function in the
database and couldn't find it.

On Mon, Jan 15, 2018 at 11:32 AM, caleb ayodele <ulo23k at gmail.com> wrote:

> 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/aa029c60/attachment.html>