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