postgres 9.5 and postgres 9.6 with postgres app

POSTGRES 9.5 AND POSTGRES 9.6 WITH POSTGRES APP HOW TO

Pg_ctl: no server data]$ /opt/PostgreSQL/9.4/bin/pg_ctl -D /opt/PostgreSQL/9.4/data status

# 'local' is for Unix domain socket connections onlyģ. Stop the 9.6 PostgreSQL cluster, but we can keep up and running 9.4 PostgreSQL data]$ /opt/PostgreSQL/9.6/bin/pg_ctl -D /opt/PostgreSQL/9.6/data status New Data Directory: /opt/PostgreSQL/9.6/data/ġ. Download & install the 9.6 PostgreSQL on the /opt/PostgreSQL/9.6/bin/ location and create the PostgreSQL database cluster on the /opt/PostgreSQL/9.6/data locationĢ. Change/add the below entries in pg_hba.conf in the both home and stop and start the cluster New Binary Location: /opt/PostgreSQL/9.6/bin/ Note: If the application created in the old data directory then you need to take care before drop the old data directory.Ĭurrent Binary Location: /opt/PostgreSQL/9.4/bin/Ĭurrent Data Directory: /opt/PostgreSQL/9.4/data/ Upgrade the Cluster to 9.6 using pg_upgrade commandĭelete the old cluster binaries & Data Directory Install & create 9.6 version Cluster on the same server.Ĭheck the pre-requisites & compatibility with 9.4

POSTGRES 9.5 AND POSTGRES 9.6 WITH POSTGRES APP HOW TO

In this blog, I am going to show you how to upgrade major version from 9.4 to 9 Scenario:Ĭluster is running on RHEL 6.4 OS and current PostgreSQL version is 9.4, we will upgrade from 9.4 to 9.6.

Postgres 9.5 and postgres 9.6 with postgres app