How to upgrade PostgreSQL9.5 to 12
This video is about the up-gradation process for the PostgreSQL9.5 to 12.
Before upgrade please make sure sufficient disk space is available. Some extensions like. PostGIS will not be upgraded during this process. You may drop the extension from 9.5, installed it on Postgres12, and create the extension. It's recommended to take a backup before doing the up-gradation process on the production environment.
Please find the below list of commands used in the up-gradation process.
Install the repository RPM:
sudo yum install -y https://download.postgresql.org/pub/r...
Install PostgreSQL9.5:
sudo yum install -y postgresql95-server
Initialize the database and start service:
sudo /usr/pgsql-9.5/bin/postgresql95-setup initdb
Install PostgreSQL12:
sudo yum install -y postgresql12-server
Initialize the database and start service:
sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
PostgeSQL upgrade command syntax
pg_upgrade -b oldbindir -B newbindir -d oldconfigdir -D newconfigdir [option...]
PostgeSQL Cluster compatibity check
/usr/pgsql-12/bin/pg_upgrade --old-bindir /usr/pgsql-9.5/bin/ --new-bindir /usr/pgsql-12/bin/ --old-datadir /var/lib/pgsql/9.5/data/ --new-datadir /var/lib/pgsql/12/data --link --check
Upgrade Command
/usr/pgsql-12/bin/pg_upgrade --old-bindir /usr/pgsql-9.5/bin/ --new-bindir /usr/pgsql-12/bin/ --old-datadir /var/lib/pgsql/9.5/data/ --new-datadir /var/lib/pgsql/12/data --link
#postgresql
Watch video How to upgrade PostgreSQL9.5 to 12 online without registration, duration hours minute second in high quality. This video was added by user Dignesh Patel 10 February 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,698 once and liked it 32 people.