[Bucardo-general] Bucardo 5.0 Add sync error - need help!

[Bhanu Gandikota]

Hi there, I'm trying to install/configure Bucardo 5.0 between Postgres 9.0.8 and 9.3.4 databases on Linux.



During the add sync step, I'm getting an error 'Failed to add sync: DBD::Pg::st execute failed: ERROR:  DBD::Pg::st execute failed: ERROR:  schema "bucardo" does not exist'

I checked both source and target DBs, schem bucardo does exist!!



*********************************************

-bash-3.2$ bucardo_ctl  add  sync  pg934_upgrade_sync  type=pushdelta  source=pg934_upgrade_herd  targetdb=pgdb_934  status=inactive



WARNING:  Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=TESTEBATES;host=x.x.x.x;port=5437 at line 191.

CONTEXT:  PL/Perl function "validate_sync"

SQL statement "SELECT validate_sync('pg934_upgrade_sync')"

PL/Perl function "validate_sync"

WARNING:  Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=EBPRD1_908;host=x.x.x.x;port=5432 at line 191.

CONTEXT:  PL/Perl function "validate_sync"

SQL statement "SELECT validate_sync('pg934_upgrade_sync')"

PL/Perl function "validate_sync"

Failed to add sync: DBD::Pg::st execute failed: ERROR:  DBD::Pg::st execute failed: ERROR:  schema "bucardo" does not exist

LINE 1: SELECT 1 FROM bucardo.bucardo_delta_targets WHERE tablename=...

                      ^ at line 191. at line 30.

CONTEXT:  PL/Perl function "validate_sync" at /usr/bin/bucardo_ctl line 3362.

***********************************************



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140520/3e5b9d34/attachment.html>