Hello Experts, I am upgrading RDS pg9.3 instance to pg10 RDS instance using bucardo. I have sucessfylly upgraded test instances. Productions it is failed.
Below are the steps I fallowed. bucardo add db source_db bucardo add db target_db bucardo add all tables db=source_db pkonly relgroup=relgroup_name bucardo add all sequences db=source_db relgroup bucardo add dbgroup db_group_name source_db:source target_db:target bucardo add sync syncname relgroup=relgroup_name dbs=db_group_name autokick=0 taken dump from source and restored it on target bucardo add sync syncname relgroup=relgorup_name dbs=db_group_name autokick=1 bucardo start. bucardo status PID of Bucardo MCP: 31743 Name State Last good Time Last I/D Last bad Time ==============+========+============+=======+===========+===========+============ syncname | Bad | none | | | 06:53:01 | 1h 24m 10s bucardo validate syncname Validating sync syncname ... OK (31743) [Fri Oct 5 06:52:59 2018] MCP Active syncs: 1 (31743) [Fri Oct 5 06:52:59 2018] MCP Entering main loop (31746) [Fri Oct 5 06:52:59 2018] VAC New VAC daemon. PID=31746 (31746) [Fri Oct 5 06:52:59 2018] VAC Connected to database "source_db" with backend PID of 52659 (31743) [Fri Oct 5 06:52:59 2018] MCP Created VAC 31746 (31748) [Fri Oct 5 06:52:59 2018] CTL New controller for sync "syncname". Relgroup is " relgroup_name ", dbs is " db_group_name ". PID=31748 (31748) [Fri Oct 5 06:52:59 2018] CTL stayalive: 1 checksecs: 0 kicked: 1 (31748) [Fri Oct 5 06:52:59 2018] CTL kidsalive: 1 onetimecopy: 0 lifetimesecs: 0 (NULL) maxkicks: 0 (31748) [Fri Oct 5 06:52:59 2018] CTL Database "source_db" backend PID: 52660 (31748) [Fri Oct 5 06:52:59 2018] CTL Database "target_db" backend PID: 3097 (31743) [Fri Oct 5 06:52:59 2018] MCP Created controller 31748 for sync "offerup_sync". Kick is 1 (31750) [Fri Oct 5 06:53:01 2018] KID (offerup_sync) New kid, sync "offerup_sync" alive=1 Parent=31748 PID=31750 kicked=1 (30855) [Fri Oct 5 06:53:01 2018] KID (offerup_sync) Kid 30855 exiting at cleanup_kid. Sync "offerup_sync" public.account_follower Reason: CTL request Line: 5001 (30855) [Fri Oct 5 06:53:01 2018] KID (offerup_sync) File /var/run/bucardo/bucardo.kid.sync.offerup_sync.pid contained foreign PID 31750, so will not remove (31743) [Fri Oct 5 06:53:01 2018] MCP Starting check_sync_health (31750) [Fri Oct 5 06:56:49 2018] KID (offerup_sync) Delta count for source_db.public.table1 : 2452231 (31750) [Fri Oct 5 06:56:49 2018] KID (offerup_sync) Delta count for source_db.public.table2 : 15036 (31750) [Fri Oct 5 06:56:49 2018] KID (offerup_sync) Delta count for source_db.public.table3 : 412 root@ubuntu:/home/ubuntu# bucardo status syncname ====================================================================== Last bad : Oct 05, 2018 06:53:01 (time until fail: 1s) Sync name : offerup_sync Current state : Bad Source relgroup/database : relgroup_name / source_db Tables in sync : 333 Status : Active Check time : None Overdue time : 00:00:00 Expired time : 00:00:00 Stayalive/Kidsalive : Yes / Yes Rebuild index : No Autokick : Yes Onetimecopy : No Post-copy analyze : Yes Last error: : Failed : CTL request Line: 5001 (KID 30855) ====================================================================== Can any one please help me. Thanks in advance. Thanks & Regards, Naveen Kumar .M, *My attitude will always be based on how you treat me. *
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
