[Bucardo-general] Table to table sync not syncing

[Hailey Eckstrand]

Hello All,

I am attempting to set up a sync between 2 tables and failing. I would like
the slave table to continuously replicate the source table. I have been
using PostgreSQL databases for years but am completely new to replication
and could be missing something very obvious such as role permissions or
changing something in the pg_hba file.

On a fresh Ubuntu 14.04 vm, I have Bucardo 5.3.1 successfully installed on
a local server. I am attempting to set up a sync on a remote server from
one database to another database on the same PostgreSQL cluster.

All servers are Ubuntu 14.04 and all databases are PostgreSQL 9.3.7. On the
source and target database, I have enabled the plperl extension using CREATE
EXTENSION plperl;

Installation and bucardo setup notes are here:

https://bitbucket.org/haileye/public/wiki/bucardo_notes

In my source db, named thedon, there is a schema named replicator with 5
tables, I want to sync one of them. My target db, named nwp, has a schema
named replicator with an exact copy of one of the tables from thedon. The
table name is replicator.msp_daily_nwp.

The error I am receiving is:

 Error: none DB source_thedon state: 42P01 Error: 7 DB target_thedon_nwp
state: ? Error: none
(25187) [Thu Jun  4 05:03:09 2015] KID (don2nwp) Kid 25187 exiting at
cleanup_kid. Sync "don2nwp" Reason: DBD::Pg::st execute failed: ERROR:
 relation "bucardo.bucardo_truncate_trigger" does not exist LINE 1:
...ident(tname), MAX(EXTRACT(epoch FROM cdate)) FROM bucardo.bu...
                                                     ^ at
/usr/local/share/perl/5.18.2/Bucardo.pm line 3515. Line: 5453 Main DB
state: ? Error: none DB source_thedon state: 42P01 Error: 7 DB
target_thedon_nwp state: ? Error: none
(25124) [Thu Jun  4 05:03:09 2015] MCP Starting check_sync_health
(25191) [Thu Jun  4 05:03:19 2015] KID (don2nwp) New kid, sync "don2nwp"
alive=1 Parent=25128 PID=25191 kicked=1
(25191) [Thu Jun  4 05:03:20 2015] KID (don2nwp) Kid has died, error is:
DBD::Pg::st execute failed: ERROR:  relation
"bucardo.bucardo_truncate_trigger" does not exist LINE 1: ...ident(tname),
MAX(EXTRACT(epoch FROM cdate)) FROM bucardo.bu...
                                   ^ at
/usr/local/share/perl/5.18.2/Bucardo.pm line 3515. Line: 5453 Main DB
state: ?

Do I have to more than just
1) add the plperl extension to the source & target db
2) add the ip address of the local bucardo server to the pg_hba.conf on
thedon (I've tested and I can log into psql to the remote server (thedon)
from the local server.

Thank you,
Hailey
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20150605/acb6339c/attachment.html>