Hi. I 'm running bucardo latest under ubuntu14.x, I have some doubts.
I have 2 DB's, this are my steps. bucardo add database MASTER dbname=dvdrental bucardo add database SLAVE dbname=dvdrental_reportes host=192.168.8.121 bucardo add all tables dbname=MASTER herd=HERD1 --verbose bucardo add sync SYNC1 dbs=MASTER,SLAVE relgroup=HERD1 pushdelta bucardo update sync SYNC1 set strict_checking=0 Here everything works no issue, love it. (7324) [Sun Aug 4 18:58:16 2019] MCP Active syncs: 1 (7324) [Sun Aug 4 18:58:16 2019] MCP Entering main loop (7328) [Sun Aug 4 18:58:16 2019] VAC New VAC daemon. PID=7328 (7328) [Sun Aug 4 18:58:16 2019] VAC Connected to database "MASTER" with backend PID of 7330 (7324) [Sun Aug 4 18:58:16 2019] MCP Created VAC 7328 (7331) [Sun Aug 4 18:58:16 2019] CTL New controller for sync "SYNC1". Relgroup is "HERD1", dbs is "SYNC1". PID=7331 (7331) [Sun Aug 4 18:58:16 2019] CTL stayalive: 1 checksecs: 0 kicked: 1 (7331) [Sun Aug 4 18:58:16 2019] CTL kidsalive: 1 onetimecopy: 0 lifetimesecs: 0 (NULL) maxkicks: 0 (7324) [Sun Aug 4 18:58:16 2019] MCP Created controller 7331 for sync "SYNC1". Kick is 1 (7331) [Sun Aug 4 18:58:16 2019] CTL Database "MASTER" backend PID: 7333 (7331) [Sun Aug 4 18:58:16 2019] CTL Database "SLAVE" backend PID: 3902 (7334) [Sun Aug 4 18:58:16 2019] KID (SYNC1) New kid, sync "SYNC1" alive=1 Parent=7331 PID=7334 kicked=1 root@server1:/var/lib/postgresql# bucardo status PID of Bucardo MCP: 7324 Name State Last good Time Last I/D Last bad Time =======+========+============+=======+===========+===========+======= SYNC1 | Good | 18:58:16 | 24s | 0/0 | none | Now, let see what happen went I try to add the 2nd database: bucardo add database MASTER1 dbname=ejemplo bucardo add database SLAVE1 dbname=ejemplo_reportes host=192.168.8.121 ===here is my issue bucardo add all tables dbname=MASTER1 herd=HERD2 --verbose root@server1:/var/log/bucardo# bucardo add all tables dbname=MASTER1 herd=HERD2 --verbose Creating relgroup: HERD2 Added table public.inventory to relgroup HERD2 Added table public.actor to relgroup HERD2 Added table public.address to relgroup HERD2 Added table public.category to relgroup HERD2 Added table public.city to relgroup HERD2 Added table public.country to relgroup HERD2 Added table public.customer to relgroup HERD2 Added table public.film to relgroup HERD2 Added table public.film_actor to relgroup HERD2 Added table public.film_category to relgroup HERD2 Added table public.language to relgroup HERD2 Added table public.payment to relgroup HERD2 Added table public.rental to relgroup HERD2 Added table public.staff to relgroup HERD2 Added table public.store to relgroup HERD2 New tables added: 0 Already added: 15 Bucardo again is adding the tables from first database. How I can sync multiple databases? The next cause errors, I cannot run the next steps. bucardo add sync SYNC2 dbs=MASTER1,SLAVE1 relgroup=HERD2 pushdelta bucardo update sync SYNC2 set strict_checking=0 I was thinking that each DB must have is own herd and sync? I want to understand bucardo. Question 1: I need to stop bucardo to add another database to sync? Any help I will appreciated, thanks!!! _______________________________________________ Bucardo-general mailing list [email protected] https://bucardo.org/mailman/listinfo/bucardo-general
