Hi Folks, After the my next commit, the Director version 3.1.9 will use a new catalog format. We provide a set of scripts that permit to convert a 3.0.x (version 11) catalog to 5.0.x (version 12). We strongly recommend that you save a copy of your existing database before upgrading.
The simplest way to upgrade the database assuming you are building from source: 1. Stop any current version of Bacula from running. 2. Save a copy of your existing database. 3. Configure, build, and install the 3.1.9 version of Bacula 4. cd <your-scripts-installation-directory> 5. ./update_bacula_tables 6. If you have multiple catalogs, edit the update_bacula_tables script and put the name of another database, and then execute the script again. Repeat this until all Bacula catalogs have been updated. 7. Start the new Bacula. If everything worked, it should not print any error messages. Once the upgrade is done, you won't be able to revert to the previous version easily. The upgrade should be quite fast on MySQL backend. On PostgreSQL (and SQLite), as we replace an index, the creation time depends on the File size table, but you can edit the script and create it later without disturbing your production (see make_postgresql_tables script). Key points in this upgrade are : * Fix SQLite and PostgreSQL indexes on File table * Add Comment field in Job table * Add Reviewed field in Job table * Add index on BaseFiles * Integration of Bresto/Brestore tables (renamed as PathVisibility, PathHierarchy) * Add HasCache field in Job table (replacement of brestore_knownjobid) * Suppression of Copy and Stripe fields on JobMedia * Add Severity field on Status table Bye ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
