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
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
