Assuming a database name of
evergreen, use the following commands to apply the required database updates from the version currently installed:
# Upgrading from Evergreen 1.4.0.0:
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.0-1.4.0.1-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.1-1.4.0.2-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.2-1.4.0.3-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.3-1.4.0.4-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.4-1.4.0.5-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.5-1.4.0.6-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.6-1.4.0.7-upgrade-db.sql
# Upgrading from Evergreen 1.4.0.1:
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.1-1.4.0.2-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.2-1.4.0.3-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.3-1.4.0.4-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.4-1.4.0.5-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.5-1.4.0.6-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.6-1.4.0.7-upgrade-db.sql
# Upgrading from Evergreen 1.4.0.2:
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.2-1.4.0.3-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.3-1.4.0.4-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.4-1.4.0.5-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.5-1.4.0.6-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.6-1.4.0.7-upgrade-db.sql
# Upgrading from Evergreen 1.4.0.3:
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.3-1.4.0.4-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.4-1.4.0.5-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.5-1.4.0.6-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.6-1.4.0.7-upgrade-db.sql
# Upgrading from Evergreen 1.4.0.4:
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.4-1.4.0.5-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.5-1.4.0.6-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.6-1.4.0.7-upgrade-db.sql
# Upgrading from Evergreen 1.4.0.5:
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.5-1.4.0.6-upgrade-db.sql
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.6-1.4.0.7-upgrade-db.sql
# Upgrading from Evergreen 1.4.0.6:
psql -U evergreen -h localhost -f Open-ILS/src/sql/Pg/1.4.0.6-1.4.0.7-upgrade-db.sql