Prepare for adding high bits to Stream

[bacula/bacula] / bacula / updatedb / update_postgresql_tables_11_to_12.in

diff --git a/bacula/updatedb/update_postgresql_tables_11_to_12.in b/bacula/updatedb/update_postgresql_tables_11_to_12.in
index b6e395e727e14371d862eb540e8825154af09600..35f294ed9e8163ed1f08487ff46cd955643408ad 100644 (file)
--- a/bacula/updatedb/update_postgresql_tables_11_to_12.in
+++ b/bacula/updatedb/update_postgresql_tables_11_to_12.in
@@ -1,9 +1,9 @@
 #!/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 " "
 
@@ -70,6 +70,9 @@ COMMIT;
 
 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;
 
@@ -80,9 +83,10 @@ 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