PostgreSQL 9.3 -> 9.4 upgrade alternative.md

Disable chef from running.

In VM:

screen
sudo service tomcat7_aatams stop
sudo apt-get install postgresql-9.4-postgis-2.1

sudo service postgresql stop

sudo pg_dropcluster --stop 9.4 main # on some nodes
# This took a bit under 5 hrs on full production data
sudo time pg_upgradecluster -k -v 9.4 -m upgrade 9.3 aatams /mnt/db/1/aatams.9.4

sudo service postgresql stop
sudo mv /mnt/db/1/aatams /mnt/db/1/aatams.9.3
sudo mv /mnt/db/1/aatams.9.4 /mnt/db/1/aatams

Run chef

In chef:

sudo service tomcat7_aatams start

# Check the app - if all looks good...
sudo rm -rf /mnt/db/1/aatams.9.3