[Bucardo-general] Upgrade bucardo 5.3.1 to 5.4

[David Christensen]

Andreas,

Thanks; yes, this is a known (and fixed) bug.  We will try to get a release out soon with that fix incorporated; in the meantime you can build from git.

Best,

David
----
> On Sep 25, 2015, at 8:28 AM, Andreas Wahler <andreas.wahler at wamtek.net> wrote:
> 
> Hi,
> 
> I think, I've found the reason inside bucardo.schema file. The sequence
> is defined as
> 
>  CREATE SEQUENCE clone_id_seq;
> 
> instead of
> 
>  CREATE SEQUENCE bucardo.clone_id_seq;
> 
> During the upgrade script this file is parsed for 'bucardo.*' so this
> create sequence is never found.
> 
> Have a nice day,
> Andreas
> 
> 
> Am 25.09.2015 um 11:42 schrieb Andreas Wahler:
>>>  From line 8162, action
>>> 
>>>  CREATE TABLE bucardo.clone (
>>>  id        INTEGER     NOT NULL DEFAULT nextval('clone_id_seq'),
>>>  ...
>>>  DBD::Pg::db do failed: ERROR:  Relation 'clone_id_seq'
>>>  does not exist at /usr/local/bin/bucardo line 8530, <$fh> line 2821.
>> 
>> ( Enhanced error msg. )
>> 
>> 
>> Am 25.09.2015 um 11:27 schrieb Andreas Wahler:
>>> Dear all,
>>> 
>>> we would like to upgrade our bucardo installation 5.3.1 to current
>>> version 5.4. According the wiki after updating the package
>>> 
>>>  bucardo upgrade
>>> 
>>> should be called. Here we get the following error msg.:
>>> 
>>>  From line 8162, action CREATE TABLE bucardo.clone (
>>>  ...
>>>  DBD::Pg::db do failed: ERROR:  Relation 'clone_id_seq'
>>>  does not exist at /usr/local/bin/bucardo line 8530, <$fh> line 2821.
>>> 
>>>  (translated from German language)
>>> 
>>> So, is it necessary to remove the old bucardo installation and
>>> re-install the new version, including all snycs etc.?
>>> 
>>> Does this effects the continuously running trigger?
>>> 
>>> Thank you in advance,
>>> Andreas
>>> 
>>> 
>> _______________________________________________
>> Bucardo-general mailing list
>> Bucardo-general at bucardo.org
>> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>> 
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general

--
David Christensen
PostgreSQL Team Manager
End Point Corporation
david at endpoint.com
785-727-1171