[Bucardo-general] Install Bucardo on Amazon RDS PostgreSQL

David Christensen david at endpoint.com
Mon Jan 15 19:50:27 UTC 2018 

So what were the first errors seen (both on RDS and Bucardo’s internal logs)?

Best,

David

> On Jan 15, 2018, at 1:29 PM, caleb ayodele <ulo23k at gmail.com> wrote:
> 
> i also saw this is logs of the source RDS database instance:
> 
> 2018-01-15 18:52:12 UTC:???(???):ticadmin at auth:[12826]:ERROR: query string argument of EXECUTE is null
> 2018-01-15 18:52:12 UTC:???(???):ticadmin at auth:[12826]:CONTEXT: PL/pgSQL function bucardo.bucardo_delta_check(text,text) line 24 at EXECUTE statement
> 2018-01-15 18:52:12 UTC:???(???):ticadmin at auth:[12826]:STATEMENT: SELECT * FROM bucardo.bucardo_delta_check($1,$2)
> 2018-01-15 18:52:23 UTC::[unknown]@[unknown]:[13046]:WARNING: pg_getnameinfo_all() failed: Temporary failure in name resolution
> 2018-01-15 18:52:33 UTC:???(???):ticadmin at auth:[13046]:ERROR: query string argument of EXECUTE is null
> 2018-01-15 18:52:33 UTC:???(???):ticadmin at auth:[13046]:CONTEXT: PL/pgSQL function bucardo.bucardo_delta_check(text
> 
> On Mon, Jan 15, 2018 at 12:17 PM, caleb ayodele <ulo23k at gmail.com <mailto:ulo23k at gmail.com>> wrote:
> 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 <mailto: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/ <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://www.endpoint.com/blog/2017/06/06/amazon-aws-upgrades-to-postgres-with>
> 
> https://bucardo.org/Bucardo/Installation/ <https://bucardo.org/Bucardo/Installation/>
> 
> On Mon, Jan 15, 2018 at 11:14 AM, David Christensen <david at endpoint.com <mailto: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 <mailto: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 <mailto:Bucardo-general at bucardo.org>
>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general <https://mail.endcrypt.com/mailman/listinfo/bucardo-general>
> 
> --
> David Christensen
> End Point Corporation
> david at endpoint.com <mailto:david at endpoint.com>
> 785-727-1171 <tel:(785)%20727-1171>
> 
> 
> 
> 
> 
> 

--
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/5f66dd65/attachment-0001.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/5f66dd65/attachment-0001.sig>

More information about the Bucardo-general mailing list