Ubuntu 14.10 Postgres upgrade

upgrade pg

# Really simple upgrade script for Ubuntu 14.10 to upgrade postgres from 9.3 to LATEST STABLE
# Add the deb package   

sudo echo "deb http://apt.postgresql.org/pub/repos/apt/ utopic-pgdg main" > /etc/apt/sources.list.d/pgdg.list

# Add the key 
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

#Refresh the repo list
sudo apt-get update

# And upgrade
sudo apt-get upgrade postgresql

# If you have the contrib package installed, update that too.
sudo apt-get upgrade postgresql-contrib


#upgrade your 9.3 cluster.... 

sudo pg_dropcluster 9.4 main --stop
sudo pg_upgradecluster 9.3 main
sudo pg_dropcluster 9.3 main