[Bucardo-general] Upgrade bucardo 5.3.1 to 5.4

[Andreas Wahler]

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
>