From f9f58e0054907e37a5c035deb3907e49a7746fa7 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Tue, 1 Nov 2011 13:37:18 -0400 Subject: [PATCH] updating the script --- Open-ILS/src/sql/Pg/pines-1.6-2.1-upgrade.sh | 37 ++++++++++++++++++++++++++++ 1 file changed, 37 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/pines-1.6-2.1-upgrade.sh diff --git a/Open-ILS/src/sql/Pg/pines-1.6-2.1-upgrade.sh b/Open-ILS/src/sql/Pg/pines-1.6-2.1-upgrade.sh new file mode 100644 index 0000000000..9dab966e96 --- /dev/null +++ b/Open-ILS/src/sql/Pg/pines-1.6-2.1-upgrade.sh @@ -0,0 +1,37 @@ +#!/bin/bash +# +# Copyright (C) 2011 Georgia Public Library Service +# Chris Sharp +# +# This program is free software; you can redistribute it and/or +# modify it under the terms of the GNU General Public License +# as published by the Free Software Foundation; either version 2 +# of the License, or (at your option) any later version. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# + +# before running, create the evergreen user and evergreen database; +# as the postgres OS user: +# createuser -s -P evergreen +# + +PGUSER=evergreen + +# tell syslog that we're beginning the process +echo "Beginning the 1.6.1-2.1 upgrade script" +logger Beginning the 1.6.1-2.1 upgrade script. + +# Run the pre-1.6.1-2.1 upgrade script to restore the auditor schema as of 1.6.1.8 +# and drop a couple of custom reporter views to be restored after the upgrade + +time /usr/bin/psql -f /root/pines/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql +logger pines-pre-1.6.1-2.1-upgrade.sql script complete + +# Run the 1.6.1-2.0 upgrade script + +time /usr/bin/psql -f /root/pines/OpenILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql +logger 1.6.1-2.0-upgrade-db.sql script complete -- 2.11.0