Further testing - this problem does not occur if the second table with the same name is added through 'bucardo add all tables'
Michelle Michelle Sullivan wrote: > 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
