Upgrade postgres ubuntu

up_postgres.sh

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

wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get upgrade


sudo apt-get install postgresql-9.6 postgresql-contrib-9.6 libpq-dev

cd /tmp

sudo service postgresql stop

sudo -H -u postgres /usr/lib/postgresql/9.6/bin/pg_upgrade \
   -b /usr/lib/postgresql/9.5/bin \
   -B /usr/lib/postgresql/9.6/bin \
   -d /var/lib/postgresql/9.5/main \
   -D /var/lib/postgresql/9.6/main \
   -o ' -c config_file=/etc/postgresql/9.5/main/postgresql.conf' \
   -O ' -c config_file=/etc/postgresql/9.6/main/postgresql.conf'

sudo service postgresql start
sudo -H -u postgres ./analyze_new_cluster.sh


sudo -H -u postgres ./delete_old_cluster.sh