From 62e39b0eea0722a12ddad81859a6b4fde430ef83 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Sun, 16 Sep 2012 13:37:37 -0400 Subject: [PATCH] Beginning bash wrapper around pines upgrade --- .../sql/Pg/version-upgrade/pines-2.1-2.2-upgrade.sh | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade.sh diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade.sh b/Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade.sh new file mode 100644 index 0000000000..0db7937aae --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-2.1-2.2-upgrade.sh @@ -0,0 +1,20 @@ +#!/bin/bash + +ADMIN_EMAIL="address@example.com" +PGUSER="evergreen" +DBNAME="evergreen" +SCRIPTS="pines-pre-2.1-2.2-upgrade.sql +2.1.1-2.1.2-upgrade-db.sql" +DBHOST="$(hostname -f)" + + +echo "Beginning PINES database upgrade on $DBHOST." | mutt -s "INFO: Beginning DB Upgrade." $ADMIN_EMAIL +logger "Beginning PINES database upgrade." + +for script in $SCRIPTS; do + psql -f $script $DBNAME && + echo "Completed script $script on $DBHOST." | mutt -s "INFO: Completed $script" $ADMIN_EMAIL; +done + + + -- 2.11.0