upgrade postgres and reinit

enablePostgisFunctions.sh

psql username
CREATE EXTENSION cube;
CREATE EXTENSION earthdistance;

reset database

drop schema public cascade;
create schema public;
CREATE TABLE alembic_version (version_num VARCHAR(32) NOT NULL);

setup.sh

# http://www.postgresql.org/download/linux/ubuntu/
# Create the file /etc/apt/sources.list.d/pgdg.list, and add a line for the repository
deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main

# Import the repository signing key, and update the package lists
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc |  sudo apt-key add -
sudo apt-get update

# List all postgres, get rid of everything but the latest
dpkg -l | grep postgresql

# Install the latest postgresql
sudo apt-get install postgresql

# Create ROLE
sudo su - postgres
createuser --interactive
createdb username
psql
ALTER ROLE username PASSWORD 'password';