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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)