In this article, we will see how to upgrade from PostgreSQL 10 to 11 on CentSO or Redaht.
We have following options to upgrade from PostgreSQL 10 to 11:
Logical Dump/Restore
Binary In-Place Upgrades(pg_upgrade)
Logical Replication
In this article, we are going to upgrade PostgreSQL 10 to 11 using pg_upgrade binary.
pg_upgrade -b oldbindir -B newbindir -d oldconfigdir -D newconfigdir [option...]
In this article, we will see how to install PostgreSQL 13 on Redhat.
PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
1. Install the repository
dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
2. Disable the built-in PostgreSQL module:
dnf -qy module disable postgresql
3. Install PostgreSQL 13 version using below command.
dnf install -y postgresql13-server
4. Now initialize database b running below command.
/usr/pgsql-13/bin/postgresql-13-setup initdb
5. Enable the PostgreSQL service.
systemctl enable postgresql-13
6. Start the PostgreSQL Server on Redhat or CentOS
systemctl start postgresql-13
7. Check the status PostgreSQL on Regdhat or CentOS
systemctl status postgresql-13
1. Switch to postgres user.
sudo su - postgres
2. Then connect to the PostgreSQL server using psql tool.
psql
3. Now change the password for user “postgres”
alter user postgres with password 'admin@123';
So, in this article, we have explained How to install PostgreSQL 13 on Redhat step by step.