O'Reilly logo

PostgreSQL High Performance Cookbook by Dinesh Kumar, Chitij Chauhan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the pg_upgrade utility for version upgrade

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.

Getting ready

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.

How to do it...

Here are the steps to upgrade a PostgreSQL machine from version 9.5 to version 9.6 using the pg_upgrade utility:

  1. Take a full backup of the data directory using a filesystem dump, or use pg_dumpall to back up the data:
            cd  /opt/pgsql/9.5/ 
    
            tar -cvf data.tar data
    
  2. The next step would to be install the new version ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required