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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> 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 <[email protected]> >> 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, <[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. Install Bucardo on Amazon RDS PostgreSQL (caleb ayodele) >>> >>> >>> ---------------------------------------------------------------------- >>> >>> Message: 1 >>> Date: Sat, 13 Jan 2018 01:01:54 -0500 >>> From: caleb ayodele <[email protected]> >>> To: [email protected] >>> Subject: [Bucardo-general] Install Bucardo on Amazon RDS PostgreSQL >>> Message-ID: <[email protected]> >>> 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 >>> [email protected] >>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general >>> >>> >>> End of Bucardo-general Digest, Vol 120, Issue 3 >>> *********************************************** >>> >>> >>> >>> _______________________________________________ >>> Bucardo-general mailing list >>> [email protected] >>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general >>> >>> >> _______________________________________________ >> Bucardo-general mailing list >> [email protected] >> https://mail.endcrypt.com/mailman/listinfo/bucardo-general >> >> >> -- >> David Christensen >> End Point Corporation >> [email protected] >> 785-727-1171 <(785)%20727-1171> >> >> >> >> >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
