So now I'm concerned, but maybe I'm misunderstanding something - the
documents, and the bucardo code, make many references to table
'bucardo_delta'.....but there is no bucardo_delta table listed in the db??
bucardo=# \d
List of relations
Schema | Name | Type | Owner
---------+-------------------------------+----------+---------
bucardo | bucardo_config | table | bucardo
bucardo | bucardo_custom_trigger | table | bucardo
bucardo | bucardo_custom_trigger_id_seq | sequence | bucardo
bucardo | bucardo_log_message | table | bucardo
bucardo | bucardo_rate | table | bucardo
bucardo | clone | table | bucardo
bucardo | clone_id_seq | sequence | bucardo
bucardo | customcode | table | bucardo
bucardo | customcode_id_seq | sequence | bucardo
bucardo | customcode_map | table | bucardo
bucardo | customcols | table | bucardo
bucardo | customcols_id_seq | sequence | bucardo
bucardo | customname | table | bucardo
bucardo | customname_id_seq | sequence | 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 | goat_id_seq | sequence | bucardo
bucardo | herd | table | bucardo
bucardo | herdmap | table | bucardo
bucardo | sync | table | bucardo
bucardo | syncrun | table | bucardo
bucardo | upgrade_log | table | bucardo
(26 rows)
I'm kind of thinking my bucardo deployment is completely broken since
the Jessie upgrade of postgresql from 9.1 to 9.4.
On 10/19/16 08:21, Paul Theodoropoulos wrote:
Well, what I'm really trying to do is escape the bizarro error. :)
I was running 5.4.1 release from Dec 2015. So last night I downloaded
the latest from github and built a fresh installation from that. I'm
beginning to think that this really is an artifact from the
OS/postgresql upgrade, not a bucardo issue. e.g. the error snippet I
forwarded was regarding public_unit_history_78 - there are 100 tables
iteratively named ...78, 79, 80, etc - but only one table is listed as
missing from bucardo's delta? Probably broken during the
pg_upgradecluster from 9.1 to 9.4, I'd imagine.
I think it might be appropriate to redeploy the syncs from scratch,
which I'll wait to do late night - perhaps over the weekend.
On 10/19/2016 7:29 AM, Greg Sabino Mullane wrote:
On Tue, Oct 18, 2016 at 08:27:11PM -0700, Paul Theodoropoulos wrote:
I built from the exact same source directory as the original build,
after a
'make clean'. 5.4.1... perhaps I should download the latest from
github? I
see now that this code I'm using is a year old.
Maybe back up a step: what are you trying to do? Upgrade an existing
Bucardo installation with a new version of Bucardo? Install Bucardo
from scratch?
--
Paul Theodoropoulos
www.anastrophe.com
_______________________________________________
Bucardo-general mailing list
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
