Consider the following setup script... bucardo add database sorbs_corkscrew dbhost=corkscrew.sorbs.net dbuser=**** dbpass=**** dbname=sorbs dbtype=postgres dbgroup=sorbs_at1 . . . bucardo add dbgroup sorbsmasters sorbs_corkscrew:source sorbs_helix:source sorbs_gemini:source sorbs_galaxi:source bucardo add dbgroup sorbsslaves sorbs_corkscrew:source sorbs_helix:source sorbs_gemini:source sorbs_galaxi:source . . . . .
bucardo add database dns_corkscrew dbhost=corkscrew.sorbs.net dbuser=**** dbpass=**** dbname=dns dbtype=postgres dbgroup=dns_at1:source . . . . bucardo add dbgroup dnsmasters dns_corkscrew:source dns_helix:source dns_gemini:source dns_galaxi:source bucardo add dbgroup dnsslaves dns_corkscrew:source dns_helix:source dns_gemini:source dns_galaxi:source . . . . . . . for a in . . . . . public.domains . . . . .. . . public.wnetassignments do bucardo add table $a relgroup=sorbs2 db=sorbs_corkscrew done . . . . . . . . for a in public.billing . . . public.domains . . . public.slaves do echo "*** bucardo add table $a relgroup=dns db=dns_corkscrew makedelta=dnsslaves" bucardo add table $a relgroup=dns db=dns_corkscrew makedelta=dnsslaves done And we get: The following tables are now part of the relgroup "dns": public.delagation *** bucardo add table public.domains relgroup=dns db=dns_corkscrew makedelta=dnsslaves DBD::Pg::st execute failed: ERROR: error from Perl function "herdcheck": Cannot have relations from different databases in the same relgroup (3) at line 17. at /usr/bin/bucardo line 3031. *** bucardo add table public.masters relgroup=dns db=dns_corkscrew makedelta=dnsslaves Added the following tables: public.masters The following tables are now part of the relgroup "dns": public.masters Seems herdcheck is not distinguishing 2 tables with the same name from 2 different databases on the same host. Michelle -- Michelle Sullivan http://www.mhix.org/ _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
