[Bucardo-general] missing table bucardo_truncate_trigger

[Kyle Stephenson]

Seems that I'm missing a table in the bucardo database.  I did the install
but this table was not installed with the bucardo install.  Any ideas on
how to get this table?

root at d-gp2-couch77-2:~# psql --version
psql (PostgreSQL) 9.6.1

root at d-gp2-couch77-2:~# bucardo --version
bucardo version 5.4.1

(14301) [Fri Jan 20 19:50:37 2017] KID (foobar) 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/share/perl5/Bucardo.pm line
3299. Line: 5041 Main DB state: ? Error: none DB kylea state: 42P01 Error:
7 DB kyleb state: ? Error: none
(14301) [Fri Jan 20 19:50:37 2017] KID (foobar) Kid 14301 exiting at
cleanup_kid. Sync "foobar" 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/share/perl5/Bucardo.pm line 3299. Line: 5041 Main DB state: ? Error:
none DB kylea state: 42P01 Error: 7 DB kyleb state: ? Error: none


bucardo=# \dt
                 List of relations
 Schema  |          Name          | Type  |  Owner
---------+------------------------+-------+---------
 bucardo | bucardo_config         | table | bucardo
 bucardo | bucardo_custom_trigger | table | bucardo
 bucardo | bucardo_log_message    | table | bucardo
 bucardo | bucardo_rate           | table | bucardo
 bucardo | clone                  | table | bucardo
 bucardo | customcode             | table | bucardo
 bucardo | customcode_map         | table | bucardo
 bucardo | customcols             | table | bucardo
 bucardo | customname             | table | bucardo
 bucardo | db                     | table | bucardo
 bucardo | db_connlog             | table | bucardo
 bucardo | dbgroup                | table | bucardo
 bucardo | dbmap                  | table | bucardo
 bucardo | dbrun                  | table | bucardo
 bucardo | goat                   | table | bucardo
 bucardo | herd                   | table | bucardo
 bucardo | herdmap                | table | bucardo
 bucardo | sync                   | table | bucardo
 bucardo | syncrun                | table | bucardo
 bucardo | upgrade_log            | table | bucardo
(20 rows)


Thanks,

Kyle Stephenson
Mobile 801.310.1451
kyle.m.stephenson at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170120/6c14071c/attachment.html>