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:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | [root@techdatabasket ~]# whoamiroot[root@techdatabasket ~]# yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpmLoaded plugins: fastestmirrorpgdg-redhat-repo-latest.noarch.rpm | 5.6 kB 00:00:00Examining /var/tmp/yum-root-CnPAZq/pgdg-redhat-repo-latest.noarch.rpm: pgdg-redhat-repo-42.0-4.noarchMarking /var/tmp/yum-root-CnPAZq/pgdg-redhat-repo-latest.noarch.rpm to be installedResolving Dependencies--> Running transaction check---> Package pgdg-redhat-repo.noarch 0:42.0-4 will be installed--> Finished Dependency ResolutionDependencies 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 PackageTotal size: 6.8 kInstalled size: 6.8 kIs this ok [y/d/N]: yDownloading packages:Running transaction checkRunning transaction testTransaction test succeededRunning transactionInstalling : pgdg-redhat-repo-42.0-4.noarch 1/1Verifying : pgdg-redhat-repo-42.0-4.noarch 1/1Installed:pgdg-redhat-repo.noarch 0:42.0-4Complete![root@techdatabasket ~]# |
Search for the installed repository using the command “yum search postgresql11”:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 | [root@techdatabasket ~]# yum search postgresql11Loaded plugins: fastestmirrorDetermining fastest mirrors<ul> <li>base: mirrors.mit.edu</li> <li>extras: centos.mirror.constant.com</li> <li>updates: mirror.atlanticmetro.netbase | 3.6 kB 00:00:00extras | 2.9 kB 00:00:00pgdg10 | 3.6 kB 00:00:00pgdg11 | 3.6 kB 00:00:00pgdg94 | 3.6 kB 00:00:00pgdg95 | 3.6 kB 00:00:00pgdg96 | 3.6 kB 00:00:00updates | 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 postgresql11postgresql11.x86_64 : PostgreSQL client programs and librariespostgresql11-contrib.x86_64 : Contributed source and binaries distributed with PostgreSQLpostgresql11-devel.x86_64 : PostgreSQL development header files and librariespostgresql11-docs.x86_64 : Extra documentation for PostgreSQLpostgresql11-libs.x86_64 : The shared libraries required for any PostgreSQL clientspostgresql11-llvmjit.x86_64 : Just-in-time compilation support for PostgreSQLpostgresql11-odbc.x86_64 : PostgreSQL ODBC driverpostgresql11-plperl.x86_64 : The Perl procedural language for PostgreSQLpostgresql11-plpython.x86_64 : The Python procedural language for PostgreSQLpostgresql11-pltcl.x86_64 : The Tcl procedural language for PostgreSQLpostgresql11-server.x86_64 : The programs needed to create and run a PostgreSQL serverpostgresql11-tcl.x86_64 : A Tcl client library for PostgreSQLpostgresql11-test.x86_64 : The test suite distributed with PostgreSQLName 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” :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 | [root@techdatabasket ~]# yum install postgresql11 postgresql11-contrib postgresql11-serverLoaded plugins: fastestmirrorLoading mirror speeds from cached hostfile<ul> <li>base: mirrors.mit.edu</li> <li>extras: centos.mirror.constant.com</li> <li>updates: mirror.atlanticmetro.netResolving 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 Mpostgresql11-contrib x86_64 11.5-1PGDG.rhel7 pgdg11 617 kpostgresql11-server x86_64 11.5-1PGDG.rhel7 pgdg11 4.7 MInstalling for dependencies:libicu x86_64 50.2-3.el7 base 6.9 Mlibxslt x86_64 1.1.28-5.el7 base 242 kperl x86_64 4:5.16.3-294.el7_6 base 8.0 Mperl-Carp noarch 1.26-244.el7 base 19 kperl-Encode x86_64 2.51-7.el7 base 1.5 Mperl-Exporter noarch 5.68-3.el7 base 28 kperl-File-Path noarch 2.09-2.el7 base 26 kperl-File-Temp noarch 0.23.01-3.el7 base 56 kperl-Filter x86_64 1.49-3.el7 base 76 kperl-Getopt-Long noarch 2.40-3.el7 base 56 kperl-HTTP-Tiny noarch 0.033-3.el7 base 38 kperl-PathTools x86_64 3.40-5.el7 base 82 kperl-Pod-Escapes noarch 1:1.04-294.el7_6 base 51 kperl-Pod-Perldoc noarch 3.20-4.el7 base 87 kperl-Pod-Simple noarch 1:3.28-4.el7 base 216 kperl-Pod-Usage noarch 1.63-3.el7 base 27 kperl-Scalar-List-Utils x86_64 1.27-248.el7 base 36 kperl-Socket x86_64 2.010-4.el7 base 49 kperl-Storable x86_64 2.45-3.el7 base 77 kperl-Text-ParseWords noarch 3.29-4.el7 base 14 kperl-Time-HiRes x86_64 4:1.9725-3.el7 base 45 kperl-Time-Local noarch 1.2300-2.el7 base 24 kperl-constant noarch 1.27-2.el7 base 19 kperl-libs x86_64 4:5.16.3-294.el7_6 base 688 kperl-macros x86_64 4:5.16.3-294.el7_6 base 44 kperl-parent noarch 1:0.225-244.el7 base 12 kperl-podlators noarch 2.5.1-3.el7 base 112 kperl-threads x86_64 1.87-4.el7 base 49 kperl-threads-shared x86_64 1.43-6.el7 base 39 kpostgresql11-libs x86_64 11.5-1PGDG.rhel7 pgdg11 361 k<h1>Transaction Summary</h1>Install 3 Packages (+30 Dependent packages)Total download size: 26 MInstalled size: 92 MIs this ok [y/d/N]: yDownloading 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: NOKEYPublic 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:00warning: /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 --:--:-- ETAPublic 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:01Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7Importing 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 0eb5Package : centos-release-7-6.1810.2.el7.centos.x86_64 (installed)From : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7Is this ok [y/N]: yRetrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDGImporting 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 f0f8Package : pgdg-redhat-repo-42.0-4.noarch (installed)From : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDGIs this ok [y/N]: yRunning transaction checkRunning transaction testTransaction test succeededRunning transactionInstalling : postgresql11-libs-11.5-1PGDG.rhel7.x86_64 1/33Installing : libicu-50.2-3.el7.x86_64 2/33Installing : postgresql11-11.5-1PGDG.rhel7.x86_64 3/33Installing : 1:perl-parent-0.225-244.el7.noarch 4/33Installing : perl-HTTP-Tiny-0.033-3.el7.noarch 5/33Installing : perl-podlators-2.5.1-3.el7.noarch 6/33Installing : perl-Pod-Perldoc-3.20-4.el7.noarch 7/33Installing : 1:perl-Pod-Escapes-1.04-294.el7_6.noarch 8/33Installing : perl-Encode-2.51-7.el7.x86_64 9/33Installing : perl-Text-ParseWords-3.29-4.el7.noarch 10/33Installing : perl-Pod-Usage-1.63-3.el7.noarch 11/33Installing : 4:perl-libs-5.16.3-294.el7_6.x86_64 12/33Installing : 4:perl-macros-5.16.3-294.el7_6.x86_64 13/33Installing : perl-Storable-2.45-3.el7.x86_64 14/33Installing : perl-Exporter-5.68-3.el7.noarch 15/33Installing : perl-constant-1.27-2.el7.noarch 16/33Installing : perl-Time-Local-1.2300-2.el7.noarch 17/33Installing : perl-Socket-2.010-4.el7.x86_64 18/33Installing : perl-Carp-1.26-244.el7.noarch 19/33Installing : 4:perl-Time-HiRes-1.9725-3.el7.x86_64 20/33Installing : perl-PathTools-3.40-5.el7.x86_64 21/33Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64 22/33Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch 23/33Installing : perl-File-Temp-0.23.01-3.el7.noarch 24/33Installing : perl-File-Path-2.09-2.el7.noarch 25/33Installing : perl-threads-shared-1.43-6.el7.x86_64 26/33Installing : perl-threads-1.87-4.el7.x86_64 27/33Installing : perl-Filter-1.49-3.el7.x86_64 28/33Installing : perl-Getopt-Long-2.40-3.el7.noarch 29/33Installing : 4:perl-5.16.3-294.el7_6.x86_64 30/33Installing : libxslt-1.1.28-5.el7.x86_64 31/33Installing : postgresql11-contrib-11.5-1PGDG.rhel7.x86_64 32/33Installing : postgresql11-server-11.5-1PGDG.rhel7.x86_64 33/33Verifying : perl-HTTP-Tiny-0.033-3.el7.noarch 1/33Verifying : postgresql11-contrib-11.5-1PGDG.rhel7.x86_64 2/33Verifying : perl-threads-shared-1.43-6.el7.x86_64 3/33Verifying : perl-Storable-2.45-3.el7.x86_64 4/33Verifying : 1:perl-Pod-Escapes-1.04-294.el7_6.noarch 5/33Verifying : perl-Exporter-5.68-3.el7.noarch 6/33Verifying : perl-constant-1.27-2.el7.noarch 7/33Verifying : perl-PathTools-3.40-5.el7.x86_64 8/33Verifying : postgresql11-libs-11.5-1PGDG.rhel7.x86_64 9/33Verifying : 1:perl-parent-0.225-244.el7.noarch 10/33Verifying : postgresql11-server-11.5-1PGDG.rhel7.x86_64 11/33Verifying : 4:perl-libs-5.16.3-294.el7_6.x86_64 12/33Verifying : perl-File-Temp-0.23.01-3.el7.noarch 13/33Verifying : 1:perl-Pod-Simple-3.28-4.el7.noarch 14/33Verifying : perl-Time-Local-1.2300-2.el7.noarch 15/33Verifying : 4:perl-macros-5.16.3-294.el7_6.x86_64 16/33Verifying : perl-Socket-2.010-4.el7.x86_64 17/33Verifying : perl-Carp-1.26-244.el7.noarch 18/33Verifying : libxslt-1.1.28-5.el7.x86_64 19/33Verifying : 4:perl-Time-HiRes-1.9725-3.el7.x86_64 20/33Verifying : perl-Scalar-List-Utils-1.27-248.el7.x86_64 21/33Verifying : perl-Pod-Usage-1.63-3.el7.noarch 22/33Verifying : perl-Encode-2.51-7.el7.x86_64 23/33Verifying : perl-Pod-Perldoc-3.20-4.el7.noarch 24/33Verifying : perl-podlators-2.5.1-3.el7.noarch 25/33Verifying : perl-File-Path-2.09-2.el7.noarch 26/33Verifying : libicu-50.2-3.el7.x86_64 27/33Verifying : perl-threads-1.87-4.el7.x86_64 28/33Verifying : perl-Filter-1.49-3.el7.x86_64 29/33Verifying : perl-Getopt-Long-2.40-3.el7.noarch 30/33Verifying : perl-Text-ParseWords-3.29-4.el7.noarch 31/33Verifying : 4:perl-5.16.3-294.el7_6.x86_64 32/33Verifying : postgresql11-11.5-1PGDG.rhel7.x86_64 33/33Installed: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.rhel7Dependency 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.el7perl-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.el7perl-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.el7perl-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.el7perl-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.el7perl-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_6perl-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.el7perl-threads-shared.x86_64 0:1.43-6.el7 postgresql11-libs.x86_64 0:11.5-1PGDG.rhel7Complete! |
You can confirm the installation of the Postgres SQL version 11 by taking a look if some packages were installed:
1 2 3 4 5 6 | [root@techdatabasket~]# rpm -qa |grep postgrespostgresql11-libs-11.5-1PGDG.rhel7.x86_64postgresql11-11.5-1PGDG.rhel7.x86_64postgresql11-server-11.5-1PGDG.rhel7.x86_64postgresql11-contrib-11.5-1PGDG.rhel7.x86_64[root@techdatabasket~]# |
You can also check the utilities
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | [root@techdatabasket~]# ls -ltr /usr/pgsql-11/bintotal 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 clusterdblrwxrwxrwx. 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)