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 <[email protected]> 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 >> [email protected] >> https://mail.endcrypt.com/mailman/listinfo/bucardo-general >> > _______________________________________________ > Bucardo-general mailing list > [email protected] > https://mail.endcrypt.com/mailman/listinfo/bucardo-general -- David Christensen PostgreSQL Team Manager End Point Corporation [email protected] 785-727-1171 _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
