Here in this recipe, we are going to talk about upgrading a PostgreSQL cluster using
pg_upgrade. We will cover the upgrading of the PostgreSQL version from 9.5 to 9.6.
The only prerequisite here is that an existing PostgreSQL cluster must be up and running. The required version here is PostgreSQL Version 9.6. These steps are carried out on a 64 bit CentOS machine.
Here are the steps to upgrade a PostgreSQL machine from version 9.5 to version 9.6 using the
pg_dumpallto back up the data:
cd /opt/pgsql/9.5/ tar -cvf data.tar data