#!/bin/sh # # Copyright (C) 2000-2022 Kern Sibbald # License: BSD 2-Clause; see file LICENSE-FOSS # # echo " " echo "This script will update a Bacula PostgreSQL database from version 1025 to 1026" echo " " bindir=@POSTGRESQL_BINDIR@ PATH="$bindir:$PATH" db_name=${db_name:-@db_name@} DBVERSION=`psql -d ${db_name} -t --pset format=unaligned -c "select VersionId from Version" $*` if [ $DBVERSION != 1025 ] ; then echo " " echo "The existing database is version $DBVERSION !!" echo "This script can only update an existing version 1025 database to version 1026." echo "Error. Cannot upgrade this database." echo " " exit 1 fi if psql -f - -d ${db_name} $* <