PSQL Upgrade

1. Create data backup

   $ pg_dump <database_name> ~/database-before-upgrade.backup -U <user>
   

2. Enable PostgreSQL Apt Repository

   $ wget -q https://www.postgresql.org/media/keys/ACCC4CF8.asc -O - | sudo apt-key add -
   $ sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'
   

3. Install PostgreSQL Database Server

   $ sudo apt-get update
   $ sudo apt-get install postgresql postgresql-contrib
   

4. Rename newly installed cluster

   $ sudo pg_renamecluster <new_version> main temp
   

5. Upgrade old cluster

   $ sudo pg_upgradecluster <old_version> main
   

6. Verify functionality

   cap production rails:console
   

7. Drop old clusters

   $ sudo pg_dropcluster <old_version> main
   $ sudo pg_dropcluster <new_version> temp