Mv /var/lib/pgsql/13/data/pg_hba.conf /var/lib/pgsql/13/data/pg_

Now copying the configuration file to new installation of PostgreSQL : Yum install postgresql13-server postgresql13-develĭnf install postgresql13-server postgresql13-devel Yum -enablerepo=centos-sclo-rh install llvm-toolset-7-clang Yum-config-manager -disable centos-sclo-rh Yum install -y yum-utils centos-release-scl-rh Now install the Latest version og PostgreSQL : Rpm -e -nodeps postgresql# postgresql#-devel postgresql#-libs postgresql#-server Mv /var/lib/pgsql/#/data/ /home/pgsql/#/data.old version 9,10,11 and 12 (skip this steps if you didn’t used official repo to install pgsql) do this : systemctl stop postgresql-# If you already installed from official repo i.e. Rpm -e -nodeps postgresql postgresql-devel postgresql-libs postgresql-server Mv /var/lib/pgsql/data/ /home/pgsql/data.old Uninstalling/removing the current version of PostgreSQL : systemctl stop postgresql The upgrade procedure is little bit complicated and you need to follow the below steps one by one : In this tutorial I’ll show you how you can upgrade PostgreSQL from older version to latest version at the time of writing 13 is the latest version, This is tested in CWP and other servers running centos 7 and 8 i.e.

Centos install postgresql 12