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 🙂
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)