#!/bin/sh
#
-# Shell script to update MySQL tables from Bacula Community version 3.0.x to 5.0.0
+# Shell script to update PostgreSQL tables from Bacula Community version 3.0.x to 5.0.0
#
echo " "
-echo "This script will update a Bacula MySQL database from version 11 to 12"
+echo "This script will update a Bacula PostgreSQL database from version 11 to 12"
echo " which is needed to convert from Bacula Community version 3.0.x to 5.0.x"
echo " "
CREATE INDEX basefiles_jobid_idx ON BaseFiles ( JobId );
+-- suppress output for index modification
+SET client_min_messages TO 'fatal';
+
-- Remove bad PostgreSQL index
DROP INDEX file_fp_idx;
CREATE INDEX file_jpfid_idx on File (JobId, PathId, FilenameId);
-ANALYSE;
+-- restore output
+SET client_min_messages TO DEFAULT;
-UPDATE Version SET VersionId=12;
+ANALYSE;
END-OF-DATA
then