PostgreSQL 11 installation on Centos el7.x86_64

When it comes to perform the installation of the database engine Postgres SQL the link to download the software is: https://yum.postgresql.org/.

Also take a look at the documentation to check the prerequisite: https://www.postgresql.org/docs/manuals/

The installation is performed using the repository and in this post I will install the version 11 on the operating system Linux centos el7.x86_64.

So, let’s install the repository with the root user:


[root@techdatabasket ~]# whoami
root
[root@techdatabasket ~]# yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Loaded plugins: fastestmirror
pgdg-redhat-repo-latest.noarch.rpm                                                                                                                                                   | 5.6 kB  00:00:00
Examining /var/tmp/yum-root-CnPAZq/pgdg-redhat-repo-latest.noarch.rpm: pgdg-redhat-repo-42.0-4.noarch
Marking /var/tmp/yum-root-CnPAZq/pgdg-redhat-repo-latest.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package pgdg-redhat-repo.noarch 0:42.0-4 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================================================================================================================================
<h1> Package                                           Arch                                    Version                                   Repository                                                        Size</h1>
Installing:
pgdg-redhat-repo                                  noarch                                  42.0-4                                    /pgdg-redhat-repo-latest.noarch                                  6.8 k
<h1>Transaction Summary</h1>
Install  1 Package

Total size: 6.8 k
Installed size: 6.8 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : pgdg-redhat-repo-42.0-4.noarch                                                                                                                                                           1/1
Verifying  : pgdg-redhat-repo-42.0-4.noarch                                                                                                                                                           1/1

Installed:
pgdg-redhat-repo.noarch 0:42.0-4

Complete!
[root@techdatabasket ~]#

Search for the installed repository using the command “yum search postgresql11”:


[root@techdatabasket ~]# yum search postgresql11
Loaded plugins: fastestmirror
Determining fastest mirrors
<ul>
 	<li>base: mirrors.mit.edu</li>
 	<li>extras: centos.mirror.constant.com</li>
 	<li>updates: mirror.atlanticmetro.net
base                                                                                                                                                                                 | 3.6 kB  00:00:00
extras                                                                                                                                                                               | 2.9 kB  00:00:00
pgdg10                                                                                                                                                                               | 3.6 kB  00:00:00
pgdg11                                                                                                                                                                               | 3.6 kB  00:00:00
pgdg94                                                                                                                                                                               | 3.6 kB  00:00:00
pgdg95                                                                                                                                                                               | 3.6 kB  00:00:00
pgdg96                                                                                                                                                                               | 3.6 kB  00:00:00
updates                                                                                                                                                                              | 2.9 kB  00:00:00
(1/14): base/7/x86_64/group_gz                                                                                                                                                       | 165 kB  00:00:00
(2/14): extras/7/x86_64/primary_db                                                                                                                                                   | 152 kB  00:00:00
(3/14): base/7/x86_64/primary_db                                                                                                                                                     | 6.0 MB  00:00:00
(4/14): pgdg10/7/x86_64/group_gz                                                                                                                                                     |  245 B  00:00:00
(5/14): pgdg10/7/x86_64/primary_db                                                                                                                                                   | 373 kB  00:00:00
(6/14): pgdg95/7/x86_64/group_gz                                                                                                                                                     |  249 B  00:00:00
(7/14): pgdg11/7/x86_64/group_gz                                                                                                                                                     |  245 B  00:00:00
(8/14): pgdg94/7/x86_64/primary_db                                                                                                                                                   | 354 kB  00:00:00
(9/14): pgdg96/7/x86_64/group_gz                                                                                                                                                     |  249 B  00:00:00
(10/14): pgdg95/7/x86_64/primary_db                                                                                                                                                  | 371 kB  00:00:00
(11/14): pgdg96/7/x86_64/primary_db                                                                                                                                                  | 383 kB  00:00:00
(12/14): pgdg94/7/x86_64/group_gz                                                                                                                                                    |  247 B  00:00:00
(13/14): updates/7/x86_64/primary_db                                                                                                                                                 | 1.1 MB  00:00:00
(14/14): pgdg11/7/x86_64/primary_db                                                                                                                                                  | 327 kB  00:00:00
======================================================================================== N/S matched: postgresql11 =========================================================================================
postgresql11-debuginfo.x86_64 : Debug information for package postgresql11
postgresql11.x86_64 : PostgreSQL client programs and libraries
postgresql11-contrib.x86_64 : Contributed source and binaries distributed with PostgreSQL
postgresql11-devel.x86_64 : PostgreSQL development header files and libraries
postgresql11-docs.x86_64 : Extra documentation for PostgreSQL
postgresql11-libs.x86_64 : The shared libraries required for any PostgreSQL clients
postgresql11-llvmjit.x86_64 : Just-in-time compilation support for PostgreSQL
postgresql11-odbc.x86_64 : PostgreSQL ODBC driver
postgresql11-plperl.x86_64 : The Perl procedural language for PostgreSQL
postgresql11-plpython.x86_64 : The Python procedural language for PostgreSQL
postgresql11-pltcl.x86_64 : The Tcl procedural language for PostgreSQL
postgresql11-server.x86_64 : The programs needed to create and run a PostgreSQL server
postgresql11-tcl.x86_64 : A Tcl client library for PostgreSQL
postgresql11-test.x86_64 : The test suite distributed with PostgreSQL

Name and summary matches only, use "search all" for everything.
[root@techdatabasket ~]#</li>
</ul>

After we have confirmed the installation of the repository, we can proceed with the installation using the command “yum install postgresql11 postgresql11-contrib postgresql11-server” :


[root@techdatabasket ~]# yum install postgresql11 postgresql11-contrib  postgresql11-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
<ul>
 	<li>base: mirrors.mit.edu</li>
 	<li>extras: centos.mirror.constant.com</li>
 	<li>updates: mirror.atlanticmetro.net
Resolving Dependencies
--> Running transaction check
---> Package postgresql11.x86_64 0:11.5-1PGDG.rhel7 will be installed
--> Processing Dependency: postgresql11-libs(x86-64) = 11.5-1PGDG.rhel7 for package: postgresql11-11.5-1PGDG.rhel7.x86_64
--> Processing Dependency: libicu for package: postgresql11-11.5-1PGDG.rhel7.x86_64
--> Processing Dependency: libpq.so.5()(64bit) for package: postgresql11-11.5-1PGDG.rhel7.x86_64
---> Package postgresql11-contrib.x86_64 0:11.5-1PGDG.rhel7 will be installed
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.22)(64bit) for package: postgresql11-contrib-11.5-1PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.18)(64bit) for package: postgresql11-contrib-11.5-1PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.11)(64bit) for package: postgresql11-contrib-11.5-1PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1()(64bit) for package: postgresql11-contrib-11.5-1PGDG.rhel7.x86_64
--> Processing Dependency: libperl.so()(64bit) for package: postgresql11-contrib-11.5-1PGDG.rhel7.x86_64
---> Package postgresql11-server.x86_64 0:11.5-1PGDG.rhel7 will be installed
--> Running transaction check
---> Package libicu.x86_64 0:50.2-3.el7 will be installed
---> Package libxslt.x86_64 0:1.1.28-5.el7 will be installed
---> Package perl-libs.x86_64 4:5.16.3-294.el7_6 will be installed
--> Processing Dependency: perl(:MODULE_COMPAT_5.16.3) for package: 4:perl-libs-5.16.3-294.el7_6.x86_64
---> Package postgresql11-libs.x86_64 0:11.5-1PGDG.rhel7 will be installed
--> Running transaction check
---> Package perl.x86_64 4:5.16.3-294.el7_6 will be installed
--> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl-macros for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(constant) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Time::HiRes) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Getopt::Long) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(File::Temp) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(File::Spec::Unix) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(File::Spec::Functions) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(File::Spec) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(File::Path) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Exporter) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Cwd) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Processing Dependency: perl(Carp) for package: 4:perl-5.16.3-294.el7_6.x86_64
--> Running transaction check
---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed
---> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed
---> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed
---> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed
---> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed
---> Package perl-Getopt-Long.noarch 0:2.40-3.el7 will be installed
--> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-3.el7.noarch
--> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-3.el7.noarch
---> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed
---> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed
--> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
--> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
---> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed
---> Package perl-Socket.x86_64 0:2.010-4.el7 will be installed
---> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed
---> Package perl-Time-HiRes.x86_64 4:1.9725-3.el7 will be installed
---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed
---> Package perl-constant.noarch 0:1.27-2.el7 will be installed
---> Package perl-macros.x86_64 4:5.16.3-294.el7_6 will be installed
---> Package perl-threads.x86_64 0:1.87-4.el7 will be installed
---> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed
--> Running transaction check
---> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed
---> Package perl-Pod-Escapes.noarch 1:1.04-294.el7_6 will be installed
---> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed
--> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch
--> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch
---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed
--> Running transaction check
---> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed
--> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
--> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
---> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed
--> Running transaction check
---> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed
---> Package perl-parent.noarch 1:0.225-244.el7 will be installed
--> Finished Dependency Resolution</li>
</ul>
Dependencies Resolved

============================================================================================================================================================================================================
<h1> Package                                                   Arch                                      Version                                                Repository                                 Size</h1>
Installing:
postgresql11                                              x86_64                                    11.5-1PGDG.rhel7                                       pgdg11                                    1.6 M
postgresql11-contrib                                      x86_64                                    11.5-1PGDG.rhel7                                       pgdg11                                    617 k
postgresql11-server                                       x86_64                                    11.5-1PGDG.rhel7                                       pgdg11                                    4.7 M
Installing for dependencies:
libicu                                                    x86_64                                    50.2-3.el7                                             base                                      6.9 M
libxslt                                                   x86_64                                    1.1.28-5.el7                                           base                                      242 k
perl                                                      x86_64                                    4:5.16.3-294.el7_6                                     base                                      8.0 M
perl-Carp                                                 noarch                                    1.26-244.el7                                           base                                       19 k
perl-Encode                                               x86_64                                    2.51-7.el7                                             base                                      1.5 M
perl-Exporter                                             noarch                                    5.68-3.el7                                             base                                       28 k
perl-File-Path                                            noarch                                    2.09-2.el7                                             base                                       26 k
perl-File-Temp                                            noarch                                    0.23.01-3.el7                                          base                                       56 k
perl-Filter                                               x86_64                                    1.49-3.el7                                             base                                       76 k
perl-Getopt-Long                                          noarch                                    2.40-3.el7                                             base                                       56 k
perl-HTTP-Tiny                                            noarch                                    0.033-3.el7                                            base                                       38 k
perl-PathTools                                            x86_64                                    3.40-5.el7                                             base                                       82 k
perl-Pod-Escapes                                          noarch                                    1:1.04-294.el7_6                                       base                                       51 k
perl-Pod-Perldoc                                          noarch                                    3.20-4.el7                                             base                                       87 k
perl-Pod-Simple                                           noarch                                    1:3.28-4.el7                                           base                                      216 k
perl-Pod-Usage                                            noarch                                    1.63-3.el7                                             base                                       27 k
perl-Scalar-List-Utils                                    x86_64                                    1.27-248.el7                                           base                                       36 k
perl-Socket                                               x86_64                                    2.010-4.el7                                            base                                       49 k
perl-Storable                                             x86_64                                    2.45-3.el7                                             base                                       77 k
perl-Text-ParseWords                                      noarch                                    3.29-4.el7                                             base                                       14 k
perl-Time-HiRes                                           x86_64                                    4:1.9725-3.el7                                         base                                       45 k
perl-Time-Local                                           noarch                                    1.2300-2.el7                                           base                                       24 k
perl-constant                                             noarch                                    1.27-2.el7                                             base                                       19 k
perl-libs                                                 x86_64                                    4:5.16.3-294.el7_6                                     base                                      688 k
perl-macros                                               x86_64                                    4:5.16.3-294.el7_6                                     base                                       44 k
perl-parent                                               noarch                                    1:0.225-244.el7                                        base                                       12 k
perl-podlators                                            noarch                                    2.5.1-3.el7                                            base                                      112 k
perl-threads                                              x86_64                                    1.87-4.el7                                             base                                       49 k
perl-threads-shared                                       x86_64                                    1.43-6.el7                                             base                                       39 k
postgresql11-libs                                         x86_64                                    11.5-1PGDG.rhel7                                       pgdg11                                    361 k
<h1>Transaction Summary</h1>
Install  3 Packages (+30 Dependent packages)

Total download size: 26 M
Installed size: 92 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7/base/packages/libxslt-1.1.28-5.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY
Public key for libxslt-1.1.28-5.el7.x86_64.rpm is not installed
(1/33): libxslt-1.1.28-5.el7.x86_64.rpm                                                                                                                                              | 242 kB  00:00:00
(2/33): libicu-50.2-3.el7.x86_64.rpm                                                                                                                                                 | 6.9 MB  00:00:00
(3/33): perl-5.16.3-294.el7_6.x86_64.rpm                                                                                                                                             | 8.0 MB  00:00:00
(4/33): perl-Carp-1.26-244.el7.noarch.rpm                                                                                                                                            |  19 kB  00:00:00
(5/33): perl-Encode-2.51-7.el7.x86_64.rpm                                                                                                                                            | 1.5 MB  00:00:00
(6/33): perl-Exporter-5.68-3.el7.noarch.rpm                                                                                                                                          |  28 kB  00:00:00
(7/33): perl-File-Path-2.09-2.el7.noarch.rpm                                                                                                                                         |  26 kB  00:00:00
(8/33): perl-Filter-1.49-3.el7.x86_64.rpm                                                                                                                                            |  76 kB  00:00:00
(9/33): perl-Getopt-Long-2.40-3.el7.noarch.rpm                                                                                                                                       |  56 kB  00:00:00
(10/33): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm                                                                                                                                       |  38 kB  00:00:00
(11/33): perl-PathTools-3.40-5.el7.x86_64.rpm                                                                                                                                        |  82 kB  00:00:00
(12/33): perl-Pod-Escapes-1.04-294.el7_6.noarch.rpm                                                                                                                                  |  51 kB  00:00:00
(13/33): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm                                                                                                                                      |  87 kB  00:00:00
(14/33): perl-Pod-Simple-3.28-4.el7.noarch.rpm                                                                                                                                       | 216 kB  00:00:00
(15/33): perl-Pod-Usage-1.63-3.el7.noarch.rpm                                                                                                                                        |  27 kB  00:00:00
(16/33): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm                                                                                                                              |  36 kB  00:00:00
(17/33): perl-File-Temp-0.23.01-3.el7.noarch.rpm                                                                                                                                     |  56 kB  00:00:00
(18/33): perl-Socket-2.010-4.el7.x86_64.rpm                                                                                                                                          |  49 kB  00:00:00
(19/33): perl-Storable-2.45-3.el7.x86_64.rpm                                                                                                                                         |  77 kB  00:00:00
(20/33): perl-Text-ParseWords-3.29-4.el7.noarch.rpm                                                                                                                                  |  14 kB  00:00:00
(21/33): perl-Time-HiRes-1.9725-3.el7.x86_64.rpm                                                                                                                                     |  45 kB  00:00:00
(22/33): perl-constant-1.27-2.el7.noarch.rpm                                                                                                                                         |  19 kB  00:00:00
(23/33): perl-libs-5.16.3-294.el7_6.x86_64.rpm                                                                                                                                       | 688 kB  00:00:00
(24/33): perl-macros-5.16.3-294.el7_6.x86_64.rpm                                                                                                                                     |  44 kB  00:00:00
(25/33): perl-parent-0.225-244.el7.noarch.rpm                                                                                                                                        |  12 kB  00:00:00
(26/33): perl-podlators-2.5.1-3.el7.noarch.rpm                                                                                                                                       | 112 kB  00:00:00
(27/33): perl-threads-1.87-4.el7.x86_64.rpm                                                                                                                                          |  49 kB  00:00:00
(28/33): perl-Time-Local-1.2300-2.el7.noarch.rpm                                                                                                                                     |  24 kB  00:00:00
(29/33): perl-threads-shared-1.43-6.el7.x86_64.rpm                                                                                                                                   |  39 kB  00:00:00
warning: /var/cache/yum/x86_64/7/pgdg11/packages/postgresql11-contrib-11.5-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY                   ]  0.0 B/s |  18 MB  --:--:-- ETA
Public key for postgresql11-contrib-11.5-1PGDG.rhel7.x86_64.rpm is not installed
(30/33): postgresql11-contrib-11.5-1PGDG.rhel7.x86_64.rpm                                                                                                                            | 617 kB  00:00:00
(31/33): postgresql11-libs-11.5-1PGDG.rhel7.x86_64.rpm                                                                                                                               | 361 kB  00:00:00
(32/33): postgresql11-11.5-1PGDG.rhel7.x86_64.rpm                                                                                                                                    | 1.6 MB  00:00:00
<h2>(33/33): postgresql11-server-11.5-1PGDG.rhel7.x86_64.rpm                                                                                                                             | 4.7 MB  00:00:00</h2>
Total                                                                                                                                                                        14 MB/s |  26 MB  00:00:01
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
Importing GPG key 0xF4A80EB5:
Userid     : "CentOS-7 Key (CentOS 7 Official Signing Key) <a href="mailto:security@centos.org">security@centos.org</a>"
Fingerprint: 6341 ab27 53d7 8a78 a7c2 7bb1 24c6 a8a7 f4a8 0eb5
Package    : centos-release-7-6.1810.2.el7.centos.x86_64 (installed)
From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
Is this ok [y/N]: y
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Importing GPG key 0x442DF0F8:
Userid     : "PostgreSQL RPM Building Project <a href="mailto:pgsqlrpms-hackers@pgfoundry.org">pgsqlrpms-hackers@pgfoundry.org</a>"
Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
Package    : pgdg-redhat-repo-42.0-4.noarch (installed)
From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : postgresql11-libs-11.5-1PGDG.rhel7.x86_64                                                                                                                                               1/33
Installing : libicu-50.2-3.el7.x86_64                                                                                                                                                                2/33
Installing : postgresql11-11.5-1PGDG.rhel7.x86_64                                                                                                                                                    3/33
Installing : 1:perl-parent-0.225-244.el7.noarch                                                                                                                                                      4/33
Installing : perl-HTTP-Tiny-0.033-3.el7.noarch                                                                                                                                                       5/33
Installing : perl-podlators-2.5.1-3.el7.noarch                                                                                                                                                       6/33
Installing : perl-Pod-Perldoc-3.20-4.el7.noarch                                                                                                                                                      7/33
Installing : 1:perl-Pod-Escapes-1.04-294.el7_6.noarch                                                                                                                                                8/33
Installing : perl-Encode-2.51-7.el7.x86_64                                                                                                                                                           9/33
Installing : perl-Text-ParseWords-3.29-4.el7.noarch                                                                                                                                                 10/33
Installing : perl-Pod-Usage-1.63-3.el7.noarch                                                                                                                                                       11/33
Installing : 4:perl-libs-5.16.3-294.el7_6.x86_64                                                                                                                                                    12/33
Installing : 4:perl-macros-5.16.3-294.el7_6.x86_64                                                                                                                                                  13/33
Installing : perl-Storable-2.45-3.el7.x86_64                                                                                                                                                        14/33
Installing : perl-Exporter-5.68-3.el7.noarch                                                                                                                                                        15/33
Installing : perl-constant-1.27-2.el7.noarch                                                                                                                                                        16/33
Installing : perl-Time-Local-1.2300-2.el7.noarch                                                                                                                                                    17/33
Installing : perl-Socket-2.010-4.el7.x86_64                                                                                                                                                         18/33
Installing : perl-Carp-1.26-244.el7.noarch                                                                                                                                                          19/33
Installing : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                                                                                                                                  20/33
Installing : perl-PathTools-3.40-5.el7.x86_64                                                                                                                                                       21/33
Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                                                                                                                             22/33
Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch                                                                                                                                                    23/33
Installing : perl-File-Temp-0.23.01-3.el7.noarch                                                                                                                                                    24/33
Installing : perl-File-Path-2.09-2.el7.noarch                                                                                                                                                       25/33
Installing : perl-threads-shared-1.43-6.el7.x86_64                                                                                                                                                  26/33
Installing : perl-threads-1.87-4.el7.x86_64                                                                                                                                                         27/33
Installing : perl-Filter-1.49-3.el7.x86_64                                                                                                                                                          28/33
Installing : perl-Getopt-Long-2.40-3.el7.noarch                                                                                                                                                     29/33
Installing : 4:perl-5.16.3-294.el7_6.x86_64                                                                                                                                                         30/33
Installing : libxslt-1.1.28-5.el7.x86_64                                                                                                                                                            31/33
Installing : postgresql11-contrib-11.5-1PGDG.rhel7.x86_64                                                                                                                                           32/33
Installing : postgresql11-server-11.5-1PGDG.rhel7.x86_64                                                                                                                                            33/33
Verifying  : perl-HTTP-Tiny-0.033-3.el7.noarch                                                                                                                                                       1/33
Verifying  : postgresql11-contrib-11.5-1PGDG.rhel7.x86_64                                                                                                                                            2/33
Verifying  : perl-threads-shared-1.43-6.el7.x86_64                                                                                                                                                   3/33
Verifying  : perl-Storable-2.45-3.el7.x86_64                                                                                                                                                         4/33
Verifying  : 1:perl-Pod-Escapes-1.04-294.el7_6.noarch                                                                                                                                                5/33
Verifying  : perl-Exporter-5.68-3.el7.noarch                                                                                                                                                         6/33
Verifying  : perl-constant-1.27-2.el7.noarch                                                                                                                                                         7/33
Verifying  : perl-PathTools-3.40-5.el7.x86_64                                                                                                                                                        8/33
Verifying  : postgresql11-libs-11.5-1PGDG.rhel7.x86_64                                                                                                                                               9/33
Verifying  : 1:perl-parent-0.225-244.el7.noarch                                                                                                                                                     10/33
Verifying  : postgresql11-server-11.5-1PGDG.rhel7.x86_64                                                                                                                                            11/33
Verifying  : 4:perl-libs-5.16.3-294.el7_6.x86_64                                                                                                                                                    12/33
Verifying  : perl-File-Temp-0.23.01-3.el7.noarch                                                                                                                                                    13/33
Verifying  : 1:perl-Pod-Simple-3.28-4.el7.noarch                                                                                                                                                    14/33
Verifying  : perl-Time-Local-1.2300-2.el7.noarch                                                                                                                                                    15/33
Verifying  : 4:perl-macros-5.16.3-294.el7_6.x86_64                                                                                                                                                  16/33
Verifying  : perl-Socket-2.010-4.el7.x86_64                                                                                                                                                         17/33
Verifying  : perl-Carp-1.26-244.el7.noarch                                                                                                                                                          18/33
Verifying  : libxslt-1.1.28-5.el7.x86_64                                                                                                                                                            19/33
Verifying  : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                                                                                                                                  20/33
Verifying  : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                                                                                                                             21/33
Verifying  : perl-Pod-Usage-1.63-3.el7.noarch                                                                                                                                                       22/33
Verifying  : perl-Encode-2.51-7.el7.x86_64                                                                                                                                                          23/33
Verifying  : perl-Pod-Perldoc-3.20-4.el7.noarch                                                                                                                                                     24/33
Verifying  : perl-podlators-2.5.1-3.el7.noarch                                                                                                                                                      25/33
Verifying  : perl-File-Path-2.09-2.el7.noarch                                                                                                                                                       26/33
Verifying  : libicu-50.2-3.el7.x86_64                                                                                                                                                               27/33
Verifying  : perl-threads-1.87-4.el7.x86_64                                                                                                                                                         28/33
Verifying  : perl-Filter-1.49-3.el7.x86_64                                                                                                                                                          29/33
Verifying  : perl-Getopt-Long-2.40-3.el7.noarch                                                                                                                                                     30/33
Verifying  : perl-Text-ParseWords-3.29-4.el7.noarch                                                                                                                                                 31/33
Verifying  : 4:perl-5.16.3-294.el7_6.x86_64                                                                                                                                                         32/33
Verifying  : postgresql11-11.5-1PGDG.rhel7.x86_64                                                                                                                                                   33/33

Installed:
postgresql11.x86_64 0:11.5-1PGDG.rhel7                        postgresql11-contrib.x86_64 0:11.5-1PGDG.rhel7                        postgresql11-server.x86_64 0:11.5-1PGDG.rhel7

Dependency Installed:
libicu.x86_64 0:50.2-3.el7                            libxslt.x86_64 0:1.1.28-5.el7                        perl.x86_64 4:5.16.3-294.el7_6               perl-Carp.noarch 0:1.26-244.el7
perl-Encode.x86_64 0:2.51-7.el7                       perl-Exporter.noarch 0:5.68-3.el7                    perl-File-Path.noarch 0:2.09-2.el7           perl-File-Temp.noarch 0:0.23.01-3.el7
perl-Filter.x86_64 0:1.49-3.el7                       perl-Getopt-Long.noarch 0:2.40-3.el7                 perl-HTTP-Tiny.noarch 0:0.033-3.el7          perl-PathTools.x86_64 0:3.40-5.el7
perl-Pod-Escapes.noarch 1:1.04-294.el7_6              perl-Pod-Perldoc.noarch 0:3.20-4.el7                 perl-Pod-Simple.noarch 1:3.28-4.el7          perl-Pod-Usage.noarch 0:1.63-3.el7
perl-Scalar-List-Utils.x86_64 0:1.27-248.el7          perl-Socket.x86_64 0:2.010-4.el7                     perl-Storable.x86_64 0:2.45-3.el7            perl-Text-ParseWords.noarch 0:3.29-4.el7
perl-Time-HiRes.x86_64 4:1.9725-3.el7                 perl-Time-Local.noarch 0:1.2300-2.el7                perl-constant.noarch 0:1.27-2.el7            perl-libs.x86_64 4:5.16.3-294.el7_6
perl-macros.x86_64 4:5.16.3-294.el7_6                 perl-parent.noarch 1:0.225-244.el7                   perl-podlators.noarch 0:2.5.1-3.el7          perl-threads.x86_64 0:1.87-4.el7
perl-threads-shared.x86_64 0:1.43-6.el7               postgresql11-libs.x86_64 0:11.5-1PGDG.rhel7

Complete!

You can confirm the installation of the Postgres SQL version 11 by taking a look if some packages were installed:


[root@techdatabasket~]# rpm -qa |grep postgres
postgresql11-libs-11.5-1PGDG.rhel7.x86_64
postgresql11-11.5-1PGDG.rhel7.x86_64
postgresql11-server-11.5-1PGDG.rhel7.x86_64
postgresql11-contrib-11.5-1PGDG.rhel7.x86_64
[root@techdatabasket~]#

You can also check the utilities


[root@techdatabasket~]# ls -ltr /usr/pgsql-11/bin
total 10188
-rwxr-xr-x. 1 root root    9418 Aug  7 22:20 postgresql-11-setup
-rwxr-xr-x. 1 root root    2175 Aug  7 22:20 postgresql-11-check-db-dir
-rwxr-xr-x. 1 root root   28744 Aug  7 22:20 vacuumlo
-rwxr-xr-x. 1 root root   63328 Aug  7 22:20 vacuumdb
-rwxr-xr-x. 1 root root   59008 Aug  7 22:20 reindexdb
-rwxr-xr-x. 1 root root  606696 Aug  7 22:20 psql
-rwxr-xr-x. 1 root root 7436376 Aug  7 22:20 postgres
-rwxr-xr-x. 1 root root   79736 Aug  7 22:20 pg_waldump
-rwxr-xr-x. 1 root root   41448 Aug  7 22:20 pg_verify_checksums
-rwxr-xr-x. 1 root root  125880 Aug  7 22:20 pg_upgrade
-rwxr-xr-x. 1 root root   24848 Aug  7 22:20 pg_test_timing
-rwxr-xr-x. 1 root root   29152 Aug  7 22:20 pg_test_fsync
-rwxr-xr-x. 1 root root   24680 Aug  7 22:20 pg_standby
-rwxr-xr-x. 1 root root   83944 Aug  7 22:20 pg_rewind
-rwxr-xr-x. 1 root root  159624 Aug  7 22:20 pg_restore
-rwxr-xr-x. 1 root root   50080 Aug  7 22:20 pg_resetwal
-rwxr-xr-x. 1 root root   72032 Aug  7 22:20 pg_recvlogical
-rwxr-xr-x. 1 root root   71888 Aug  7 22:20 pg_receivewal
-rwxr-xr-x. 1 root root   54504 Aug  7 22:20 pg_isready
-rwxr-xr-x. 1 root root   88688 Aug  7 22:20 pg_dumpall
-rwxr-xr-x. 1 root root  392656 Aug  7 22:20 pg_dump
-rwxr-xr-x. 1 root root   54320 Aug  7 22:20 pg_ctl
-rwxr-xr-x. 1 root root   41344 Aug  7 22:20 pg_controldata
-rwxr-xr-x. 1 root root   28824 Aug  7 22:20 pg_config
-rwxr-xr-x. 1 root root  142984 Aug  7 22:20 pgbench
-rwxr-xr-x. 1 root root  109784 Aug  7 22:20 pg_basebackup
-rwxr-xr-x. 1 root root   28888 Aug  7 22:20 pg_archivecleanup
-rwxr-xr-x. 1 root root   28832 Aug  7 22:20 oid2name
-rwxr-xr-x. 1 root root  122000 Aug  7 22:20 initdb
-rwxr-xr-x. 1 root root   54584 Aug  7 22:20 dropuser
-rwxr-xr-x. 1 root root   54592 Aug  7 22:20 dropdb
-rwxr-xr-x. 1 root root   59344 Aug  7 22:20 createuser
-rwxr-xr-x. 1 root root   58920 Aug  7 22:20 createdb
-rwxr-xr-x. 1 root root   58936 Aug  7 22:20 clusterdb
lrwxrwxrwx. 1 root root       8 Oct  1 12:38 postmaster -> postgres
[root@techdatabasket~]#
[root@techdatabasket~]#

Now you have your PostgreSQL version 11 installed 🙂

Related posts

Leave a Comment