Steps to install PostgreSQL version 14 on centos 7 ?

In this article, we will see the steps to install postgresql on Centos/RHEL Operating system.

The same steps can be followed to install any version, however you need to change the repo path according to the version.

Here we have installed PostgreSQL version 14 on Centos 7.4 Operating System.

1. Check for available version in centos repository.

[root@ngelinux001 ~]# yum list all | grep -i postgre
postgresql.x86_64 9.2.21-1.el7 @anaconda
postgresql-devel.x86_64 9.2.21-1.el7 @anaconda
postgresql-docs.x86_64 9.2.21-1.el7 @anaconda
postgresql-libs.x86_64 9.2.21-1.el7 @anaconda
postgresql-odbc.x86_64 09.03.0100-2.el7 @anaconda
postgresql-server.x86_64 9.2.21-1.el7 @anaconda
qt-postgresql.x86_64 1:4.8.5-13.el7 @anaconda
qt3-PostgreSQL.x86_64 3.3.8b-51.el7 @anaconda
qt5-qtbase-postgresql.x86_64 5.6.2-1.el7 @anaconda
freeradius-postgresql.x86_64 3.0.13-15.el7 base
libreoffice-postgresql.x86_64 1:5.3.6.1-25.el7_9 updates
pcp-pmda-postgresql.x86_64 4.3.2-13.el7_9 updates
postgresql.i686 9.2.24-7.el7_9 updates
postgresql.x86_64 9.2.24-7.el7_9 updates
postgresql-contrib.x86_64 9.2.24-7.el7_9 updates
postgresql-devel.i686 9.2.24-7.el7_9 updates
postgresql-devel.x86_64 9.2.24-7.el7_9 updates
postgresql-docs.x86_64 9.2.24-7.el7_9 updates
postgresql-jdbc.noarch 9.2.1002-8.el7_8 updates

 

2. Create repo file for version 14 as its not available with CentOS repo.

[root@ngelinux001 yum.repos.d]# cat postgresql14.repo
[postgre]
name=PostGreSQL14
baseurl=https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-7.4-x86_64/
gpgcheck=0
enabled=1
[root@ngelinux001 yum.repos.d]#

 

3. Check if you are able to get packages from repo.

[root@ngelinux001 yum.repos.d]# yum repolist
Loaded plugins: aliases, changelog, fastestmirror, kabi, langpacks, tmprepo, verify, versionlock
Loading support for Red Hat kernel ABI
postgre | 3.6 kB 00:00:00
(1/2): postgre/group_gz | 244 B 00:00:00
(2/2): postgre/primary_db | 107 kB 00:00:00
Loading mirror speeds from cached hostfile
* base: mirrors.xtom.com
* extras: mirror.fcix.net
* updates: linux.mirrors.es.net
repo id repo name status
base/7/x86_64 CentOS-7 - Base 10,072
extras/7/x86_64 CentOS-7 - Extras 512
postgre PostGreSQL14 281
updates/7/x86_64 CentOS-7 - Updates 3,842
repolist: 14,707

 

4. Now search for the package name and version available.

[root@ngelinux001 yum.repos.d]# yum list all | grep -i postgre
postgresql.x86_64 9.2.21-1.el7 @anaconda
postgresql-devel.x86_64 9.2.21-1.el7 @anaconda
postgresql-docs.x86_64 9.2.21-1.el7 @anaconda
postgresql-libs.x86_64 9.2.21-1.el7 @anaconda
postgresql-odbc.x86_64 09.03.0100-2.el7 @anaconda
postgresql-server.x86_64 9.2.21-1.el7 @anaconda
qt-postgresql.x86_64 1:4.8.5-13.el7 @anaconda
qt3-PostgreSQL.x86_64 3.3.8b-51.el7 @anaconda
qt5-qtbase-postgresql.x86_64 5.6.2-1.el7 @anaconda
bgw_replstatus_14.x86_64 1.0.3-3.rhel7 postgre
citus_14.x86_64 10.2.5-1.rhel7 postgre
postgis32_14-gui.x86_64 3.2.1-1.rhel7 postgre
postgis32_14-utils.x86_64 3.2.1-1.rhel7 postgre
postgresql.i686 9.2.24-7.el7_9 updates
postgresql.x86_64 9.2.24-7.el7_9 updates
postgresql-contrib.x86_64 9.2.24-7.el7_9 updates
postgresql-devel.i686 9.2.24-7.el7_9 updates
postgresql-devel.x86_64 9.2.24-7.el7_9 updates
postgresql-docs.x86_64 9.2.24-7.el7_9 updates
postgresql-jdbc.noarch 9.2.1002-8.el7_8 updates
postgresql-jdbc-javadoc.noarch 9.2.1002-8.el7_8 updates
postgresql-libs.i686 9.2.24-7.el7_9 updates
postgresql-libs.x86_64 9.2.24-7.el7_9 updates
postgresql-plperl.x86_64 9.2.24-7.el7_9 updates
postgresql-plpython.x86_64 9.2.24-7.el7_9 updates
postgresql-pltcl.x86_64 9.2.24-7.el7_9 updates
postgresql-server.x86_64 9.2.24-7.el7_9 updates
postgresql-static.i686 9.2.24-7.el7_9 updates
postgresql-static.x86_64 9.2.24-7.el7_9 updates
postgresql-test.x86_64 9.2.24-7.el7_9 updates
postgresql-unit_14.x86_64 7.4-1.rhel7 postgre
postgresql-upgrade.x86_64 9.2.24-7.el7_9 updates
postgresql14.x86_64 14.3-1PGDG.rhel7 postgre
postgresql14-contrib.x86_64 14.3-1PGDG.rhel7 postgre
postgresql14-devel.x86_64 14.3-1PGDG.rhel7 postgre
postgresql14-docs.x86_64 14.3-1PGDG.rhel7 postgre
postgresql14-libs.x86_64 14.3-1PGDG.rhel7 postgre
postgresql14-llvmjit.x86_64 14.3-1PGDG.rhel7 postgre
postgresql14-odbc.x86_64 13.02.0000-1PGDG.rhel7 postgre
postgresql14-plperl.x86_64 14.3-1PGDG.rhel7 postgre
postgresql14-plpython3.x86_64 14.3-1PGDG.rhel7 postgre
postgresql14-pltcl.x86_64 14.3-1PGDG.rhel7 postgre
postgresql14-server.x86_64 14.3-1PGDG.rhel7 postgre

 

5. Install the package on the server.

[root@ngelinux001 yum.repos.d]# yum install postgresql14.x86_64
Loaded plugins: aliases, changelog, fastestmirror, kabi, langpacks, tmprepo, verify, versionlock
Loading support for Red Hat kernel ABI
Loading mirror speeds from cached hostfile
* base: mirrors.xtom.com
* extras: mirror.fcix.net
* updates: linux.mirrors.es.net
Resolving Dependencies
--> Running transaction check
---> Package postgresql14.x86_64 0:14.3-1PGDG.rhel7 will be installed
--> Processing Dependency: postgresql14-libs(x86-64) = 14.3-1PGDG.rhel7 for package: postgresql14-14.3-1PGDG.rhel7.x86_64
--> Processing Dependency: lz4 for package: postgresql14-14.3-1PGDG.rhel7.x86_64
--> Running transaction check
---> Package lz4.x86_64 0:1.8.3-1.el7 will be installed
---> Package postgresql14-libs.x86_64 0:14.3-1PGDG.rhel7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================================================================
Package Arch Version Repository Size
================================================================================================================================
Installing:
postgresql14 x86_64 14.3-1PGDG.rhel7 postgre 1.5 M
Installing for dependencies:
lz4 x86_64 1.8.3-1.el7 base 85 k
postgresql14-libs x86_64 14.3-1PGDG.rhel7 postgre 268 k

Transaction Summary
================================================================================================================================
Install 1 Package (+2 Dependent packages)

Total download size: 1.8 M
Installed size: 8.9 M
Is this ok [y/d/N]: y
Downloading packages:
(1/3): lz4-1.8.3-1.el7.x86_64.rpm | 85 kB 00:00:00
(2/3): postgresql14-libs-14.3-1PGDG.rhel7.x86_64.rpm | 268 kB 00:00:01
(3/3): postgresql14-14.3-1PGDG.rhel7.x86_64.rpm | 1.5 MB 00:00:01
--------------------------------------------------------------------------------------------------------------------------------
Total 1.1 MB/s | 1.8 MB 00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
Installing : lz4-1.8.3-1.el7.x86_64 1/3
Installing : postgresql14-libs-14.3-1PGDG.rhel7.x86_64 2/3
Installing : postgresql14-14.3-1PGDG.rhel7.x86_64 3/3
failed to link /usr/bin/psql -> /etc/alternatives/pgsql-psql: /usr/bin/psql exists and it is not a symlink
failed to link /usr/bin/clusterdb -> /etc/alternatives/pgsql-clusterdb: /usr/bin/clusterdb exists and it is not a symlink
failed to link /usr/bin/createdb -> /etc/alternatives/pgsql-createdb: /usr/bin/createdb exists and it is not a symlink
failed to link /usr/bin/createuser -> /etc/alternatives/pgsql-createuser: /usr/bin/createuser exists and it is not a symlink
failed to link /usr/bin/dropdb -> /etc/alternatives/pgsql-dropdb: /usr/bin/dropdb exists and it is not a symlink
failed to link /usr/bin/dropuser -> /etc/alternatives/pgsql-dropuser: /usr/bin/dropuser exists and it is not a symlink
failed to link /usr/bin/pg_basebackup -> /etc/alternatives/pgsql-pg_basebackup: /usr/bin/pg_basebackup exists and it is not a symlink
failed to link /usr/bin/pg_dump -> /etc/alternatives/pgsql-pg_dump: /usr/bin/pg_dump exists and it is not a symlink
failed to link /usr/bin/pg_dumpall -> /etc/alternatives/pgsql-pg_dumpall: /usr/bin/pg_dumpall exists and it is not a symlink
failed to link /usr/bin/pg_restore -> /etc/alternatives/pgsql-pg_restore: /usr/bin/pg_restore exists and it is not a symlink
failed to link /usr/bin/reindexdb -> /etc/alternatives/pgsql-reindexdb: /usr/bin/reindexdb exists and it is not a symlink
failed to link /usr/bin/vacuumdb -> /etc/alternatives/pgsql-vacuumdb: /usr/bin/vacuumdb exists and it is not a symlink
Verifying : postgresql14-libs-14.3-1PGDG.rhel7.x86_64 1/3
Verifying : postgresql14-14.3-1PGDG.rhel7.x86_64 2/3
Verifying : lz4-1.8.3-1.el7.x86_64 3/3

Installed:
postgresql14.x86_64 0:14.3-1PGDG.rhel7

Dependency Installed:
lz4.x86_64 0:1.8.3-1.el7 postgresql14-libs.x86_64 0:14.3-1PGDG.rhel7

Complete!
[root@ngelinux001 yum.repos.d]#

In case the new version does not work, we need to uninstall old version and install this back.
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments