Hi. I understand fail. Need create/copy table/schema on second server. And need bucardo start (i dont start bucardo)
2017-05-17 18:50 GMT+06:00 Saiful Muhajir <[email protected]>: > Maybe you need to verify the tables and relgroups list and see if they are > correct. > > bucardo list relgroups > bucardo list tables > > > ~ > Saiful > > > On 17 May 2017 19:00, <[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. Failed to add sync: DBD::Pg::st execute failed: ERROR: Could > not find "account_" inside the "public" schema on database "db"! > at line 30. (????? ?????) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 16 May 2017 19:30:20 +0600 > From: ????? ????? <[email protected]> > To: [email protected] > Subject: [Bucardo-general] Failed to add sync: DBD::Pg::st execute > failed: ERROR: Could not find "account_" inside the "public" > schema on > database "db"! at line 30. > Message-ID: > <[email protected] > ail.com> > Content-Type: text/plain; charset="utf-8" > > > Hello! > i have error when when try sync > > I have script for automation: > > cat ./replica_add.sh > #!/bin/sh > . ./replica_env.sh > for dbname in $dbname_list ;do > dbname_s="`echo $dbname|sed -r 's/\-/_/g'`" > echo "--------------------------------------------------" > echo "DBNAME - ${dbname}" > echo "--------------------------------------------------" > bucardo add database ${dbname_s}_node1 dbname=${dbname} dbhost=${master} > dbuser=postgres > bucardo add database ${dbname_s}_node2 dbname=${dbname} dbhost=${slave} > dbuser=postgres > bucardo add table all --db=${dbname_s}_node1 --herd=${dbname_s}_herd > strict_check=0 > bucardo add sequence all --db=${dbname_s}_node1 --herd=${dbname_s}_herd > bucardo add dbgroup ${dbname_s}_servers_group ${dbname_s}_node1:source > bucardo add dbgroup ${dbname_s}_servers_group ${dbname_s}_node2:target > #bucardo add sync ${dbname_s}_sync herd=${dbname_s}_herd > dbs=${dbname_s}_servers_group onetimecopy=1 strict_checking=0 > done > echo "--------------------------------------------------" > #sudo bucardo restart > echo "done" > > cat ./replica_sync_add.sh > #!/bin/sh > . ./replica_env.sh > for dbname in $dbname_list ;do > dbname_s="`echo $dbname|sed -r 's/\-/_/g'`" > echo "--------------------------------------------------" > echo "DBNAME - ${dbname}" > echo "--------------------------------------------------" > bucardo add sync ${dbname_s}_sync herd=${dbname_s}_herd > dbs=${dbname_s}_servers_group onetimecopy=1 strict_checking=0 > done > echo "--------------------------------------------------" > #sudo bucardo restart > echo "done" > > Changed pg_hba.conf for access. Install bucardo install. > ./replica_add.sh > -------------------------------------------------- > DBNAME - subs_online_catalogue_dev > -------------------------------------------------- > Added database "subs_online_catalogue_dev_node1" > Added database "subs_online_catalogue_dev_node2" > Creating relgroup: subs_online_catalogue_dev_herd > Added table public.account_ to relgroup subs_online_catalogue_dev_herd > ..... > New tables added: 207 > Sorry, no sequences were found > New sequences added: 0 > Created dbgroup "subs_online_catalogue_dev_servers_group" > Added database "subs_online_catalogue_dev_node1" to dbgroup > "subs_online_catalogue_dev_servers_group" as source > Added database "subs_online_catalogue_dev_node2" to dbgroup > "subs_online_catalogue_dev_servers_group" as target > > ./replica_sync_add.sh > -------------------------------------------------- > DBNAME - subs_online_catalogue_dev > -------------------------------------------------- > WARNING: Issuing rollback() due to DESTROY without explicit disconnect() > of DBD::Pg::db handle dbname=subs_online_catalogue_dev;host=10.233.4.16 at > line 1018. > CONTEXT: PL/Perl function "validate_sync" > SQL statement "SELECT validate_sync('subs_online_catalogue_dev_sync')" > PL/Perl function "validate_sync" > Failed to add sync: DBD::Pg::st execute failed: ERROR: Could not find > "account_" inside the "public" schema on database > "subs_online_catalogue_dev_node2"! at line 30. > CONTEXT: PL/Perl function "validate_sync" at /sbin/bucardo line 4612. > > -------------------------------------------------- > done > > > What is wrong? > > -- > ? ?????????, ????? ?????. > Best regards, Anton Patsev. > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachm > ents/20170516/095a9bf5/attachment-0001.html> > > ------------------------------ > > _______________________________________________ > Bucardo-general mailing list > [email protected] > https://mail.endcrypt.com/mailman/listinfo/bucardo-general > > > End of Bucardo-general Digest, Vol 114, Issue 8 > *********************************************** > > > > _______________________________________________ > Bucardo-general mailing list > [email protected] > https://mail.endcrypt.com/mailman/listinfo/bucardo-general > > -- С уважением, Антон Пацев. Best regards, Anton Patsev.
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
