Hello Denny, good news: the only change from Bareos database schema 2003 to 2004 is exactly adding the filesettext column (and updating the version from 2003 to 2004), see /usr/lib/bareos/scripts/ddl/updates/postgresql.2003_2004.sql
As this change is already in place in your environment, there is probably nothing more to do. Why is the database schema already updated? In Debian (and Debian based like Ubuntu and Univention) the default behavior of Bareos is to use the dbconfig-common mechanism to setup and update the database schema, see http://doc.bareos.org/master/html/bareos-manual-main-reference.html#UpdatingTheDatabaseScheme Therefore it is not required, to run the update_bareos_tables manually. For more information, also how to verify what database schema version you are using, take a look at http://doc.bareos.org/master/html/bareos-manual-main-reference.html#CatalogMaintenance regards, Jörg Am 23.11.2015 um 22:17 schrieb Denny Fuchs: > hi, > > I have a Debian Wheezy and upgraded Bareos ... and Bareos wants a DB upgrade. > It seems, that there is a loop: > > su postgres -c /usr/lib/bareos/scripts/update_bareos_tables > > psql:/tmp/tables.sql.12423:3: ERROR: column "filesettext" of relation > "fileset" already exists | > psql:/tmp/tables.sql.12423:4: ERROR: current transaction is aborted, > commands ignored until end of transaction block | > ROLLBACK > | > SET > | > ANALYZE > | > Upgrading database schema from version 2003 to 2004 > | > BEGIN > | > psql:/tmp/tables.sql.12423:3: ERROR: column "filesettext" of relation > "fileset" already exists | > psql:/tmp/tables.sql.12423:4: ERROR: current transaction is aborted, > commands ignored until end of transaction block | > ROLLBACK > > any suggestions? > > cu denny > -- Jörg Steffens [email protected] Bareos GmbH & Co. KG Phone: +49 221 630693-91 http://www.bareos.com Fax: +49 221 630693-10 Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 Komplementär: Bareos Verwaltungs-GmbH Geschäftsführer: S. Dühr, M. Außendorf, Jörg Steffens, P. Storz, M. v. Wieringen -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
