[Bucardo-general] Fwd: customname schema change

[Hailey Eckstrand]

Hello All,

I have successfully set up a sync between 3 tables on the source database
to the target database. I have also successfully changed the name of the
target database table names, specifically the schema name. After I
successfully changed the schema name, I then deleted the not needed schema.
After I stopped & started bucardo, it then fails as it cannot find the
schema of the original table names.. here is the error:

(26992) [Tue Jun  9 09:31:38 2015] MCP Error from validate_sync:
DBD::Pg::db do failed: ERROR:  Could not find schema "replicator" in
database "target_thedon_nwp"!
CONTEXT:  PL/Perl function "validate_sync" at
/usr/local/share/perl/5.18.2/Bucardo.pm line 6598.
(26992) [Tue Jun  9 09:31:38 2015] MCP Validation of sync don2nwp FAILED

I recreated the replicator schema on the nwp database with empty tables and
it works. Is it necessary to keep the replicator schema or is it possible
to initially create the target tables with the wanted schema (water)
instead of setting it up and then changing the name?

Here is all my code:

bucardo add db source_thedon dbname="thedon" host="mylocalhost"
port="5432" user="myusername" pass="mypassword"# Added database
"source_thedon"
bucardo add db target_thedon_nwp dbname="nwp" host="mylocalhost"
port="5432" user="myusername" pass="mypassword"# Added database
"target_thedon_nwp"
bucardo add table replicator.msp_daily_nwp db=source_thedon relgroup=thedon_nwp
bucardo add table replicator.climate_daily db=source_thedon relgroup=thedon_nwp
bucardo add table replicator.water_daily_nwp db=source_thedon
relgroup=thedon_nwp
bucardo add customname replicator.msp_daily_nwp water.msp_daily_nwp
db=target_thedon_nwp
bucardo add customname replicator.climate_daily water.climate_daily
db=target_thedon_nwp
bucardo add customname replicator.water_daily_nwp
water.water_daily_nwp db=target_thedon_nwp

bucardo add sync don2nwp relgroup=thedon_nwp
dbs=source_thedon:source,target_thedon_nwp:target

sudo bucardo start -dbpass=bucardo-runner# Successful sync start


psql nwp
drop schema replicator cascade;\q

sudo bucardo stop -dbpass=bucardo-runner
sudo bucardo start -dbpass=bucardo-runner
# Then in the log file:# (27413) [Tue Jun  9 09:54:03 2015] MCP Error
from validate_sync: DBD::Pg::db do failed: ERROR:  Could not find #
schema "replicator" in database "target_thedon_nwp"!# CONTEXT:
PL/Perl function "validate_sync" at
/usr/local/share/perl/5.18.2/Bucardo.pm line 6598.# (27413) [Tue Jun
9 09:54:03 2015] MCP Validation of sync don2nwp FAILED
# The sync no longer works
# I recreated the replicator schema on the nwp database with 3 empty
tables with the correct table structure and then stopped and started
bucardo and then the sync worked.



Thank you,

Hailey
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20150609/721d49e3/attachment-0001.html>