centos7 在線安裝新版postgresql10

一、更新源

地址：https://yum.postgresql.org/repopackages.php

yum源

獲取到以上yum源鏈接地址：
centos7：
https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm

centos6：
https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6-x86_64/pgdg-centos10-10-2.noarch.rpm

安裝yum源：

yum install  -y  https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm

二逛拱、安裝postgresql

先查看postgreql源

[root@Hemny ~]# yum list | grep postgresql
freeradius-postgresql.x86_64                3.0.13-9.el7_5             updates  
libreoffice-postgresql.x86_64               1:5.3.6.1-10.el7           base     
pcp-pmda-postgresql.x86_64                  3.12.2-5.el7               base     
postgresql.i686                             9.2.24-1.el7_5             updates  
postgresql.x86_64                           9.2.24-1.el7_5             updates  
postgresql-contrib.x86_64                   9.2.24-1.el7_5             updates  
postgresql-devel.i686                       9.2.24-1.el7_5             updates  
postgresql-devel.x86_64                     9.2.24-1.el7_5             updates  
postgresql-docs.x86_64                      9.2.24-1.el7_5             updates  
postgresql-jdbc.noarch                      42.2.5-1.rhel7             pgdg10   
postgresql-jdbc-javadoc.noarch              42.2.5-1.rhel7             pgdg10   
postgresql-libs.i686                        9.2.24-1.el7_5             updates  
postgresql-libs.x86_64                      9.2.24-1.el7_5             updates  
postgresql-odbc.x86_64                      09.03.0100-2.el7           base     
postgresql-plperl.x86_64                    9.2.24-1.el7_5             updates  
postgresql-plpython.x86_64                  9.2.24-1.el7_5             updates  
postgresql-pltcl.x86_64                     9.2.24-1.el7_5             updates  
postgresql-server.x86_64                    9.2.24-1.el7_5             updates  
postgresql-static.i686                      9.2.24-1.el7_5             updates  
postgresql-static.x86_64                    9.2.24-1.el7_5             updates  
postgresql-test.x86_64                      9.2.24-1.el7_5             updates  
postgresql-unit10.x86_64                    7.0-1.rhel7                pgdg10   
postgresql-unit10-debuginfo.x86_64          7.0-1.rhel7                pgdg10   
postgresql-upgrade.x86_64                   9.2.24-1.el7_5             updates  
postgresql10.x86_64                         10.6-1PGDG.rhel7           pgdg10   
postgresql10-contrib.x86_64                 10.6-1PGDG.rhel7           pgdg10   
postgresql10-debuginfo.x86_64               10.6-1PGDG.rhel7           pgdg10   
postgresql10-devel.x86_64                   10.6-1PGDG.rhel7           pgdg10   
postgresql10-docs.x86_64                    10.6-1PGDG.rhel7           pgdg10   
postgresql10-libs.x86_64                    10.6-1PGDG.rhel7           pgdg10   
postgresql10-odbc.x86_64                    10.03.0000-1PGDG.rhel7     pgdg10   
postgresql10-plperl.x86_64                  10.6-1PGDG.rhel7           pgdg10   
postgresql10-plpython.x86_64                10.6-1PGDG.rhel7           pgdg10   
postgresql10-pltcl.x86_64                   10.6-1PGDG.rhel7           pgdg10   
postgresql10-server.x86_64                  10.6-1PGDG.rhel7           pgdg10   
postgresql10-tcl.x86_64                     2.4.0-1.rhel7              pgdg10   
postgresql10-tcl-debuginfo.x86_64           2.3.1-1.rhel7              pgdg10   
postgresql10-test.x86_64                    10.6-1PGDG.rhel7           pgdg10   
postgresql_anonymizer10.noarch              0.2.1-1.rhel7              pgdg10   
qt-postgresql.i686                          1:4.8.7-2.el7              base     
qt-postgresql.x86_64                        1:4.8.7-2.el7              base     
qt5-qtbase-postgresql.i686                  5.9.2-3.el7                base     
qt5-qtbase-postgresql.x86_64                5.9.2-3.el7                base

postgresql10-server【postgresql的服務(wù)端】
postgresql10-contrib【postgresql的extension敌厘，提供較多的拓展功能】
postgresql10【postgresql的數(shù)據(jù)庫工具組件，包含很多管理數(shù)據(jù)庫組件】
postgresql10-libs【postgresql的動態(tài)庫朽合，依賴安裝】
postgresql10-odbc【postgresql的odbc相關(guān)組件】
postgresql10-plperl【postgresql的PL/Perl,如果使用Perl開發(fā)函數(shù)俱两，需要安裝】
postgresql10-plpython【postgresql的PL/python,如果使用python開發(fā)函數(shù)，需要安裝】
postgresql10-pltcl【postgresql的PL/tcl,如果使用tcl開發(fā)函數(shù)曹步，需要安裝】
postgresql10-devel【postgresql的開發(fā)包宪彩，包含.h頭文件等】
postgresql10-test【postgresql的回歸測試組件】
postgresql10-docs【postgresql的說明文檔】

安裝postgresql。
這次安裝的是相對完整的服務(wù)端讲婚，包括組件postgresql10-server尿孔、postgresql10-contrib、postgresql10、postgresql10-libs活合、postgresql10-plperl雏婶、postgresql10-plpython、postgresql10-pltcl白指。

注意：不包括開發(fā)留晚、測試、調(diào)試告嘲、文檔错维。
輸入命令：

yum install postgresql10-server postgresql10-contrib postgresql10 postgresql10-libs postgresql10-plperl postgresql10-plpython postgresql10-pltcl

安裝過程：

[root@Hemny ~]# yum install postgresql10-server postgresql10-contrib postgresql10 postgresql10-libs postgresql10-plperl postgresql10-plpython postgresql10-pltcl
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.nju.edu.cn
 * extras: mirrors.163.com
 * updates: mirrors.163.com
Resolving Dependencies
--> Running transaction check
---> Package postgresql10.x86_64 0:10.6-1PGDG.rhel7 will be installed
--> Processing Dependency: libicu for package: postgresql10-10.6-1PGDG.rhel7.x86_64
---> Package postgresql10-contrib.x86_64 0:10.6-1PGDG.rhel7 will be installed
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.22)(64bit) for package: postgresql10-contrib-10.6-1PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.18)(64bit) for package: postgresql10-contrib-10.6-1PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.11)(64bit) for package: postgresql10-contrib-10.6-1PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1()(64bit) for package: postgresql10-contrib-10.6-1PGDG.rhel7.x86_64
--> Processing Dependency: libperl.so()(64bit) for package: postgresql10-contrib-10.6-1PGDG.rhel7.x86_64
---> Package postgresql10-libs.x86_64 0:10.6-1PGDG.rhel7 will be installed
---> Package postgresql10-plperl.x86_64 0:10.6-1PGDG.rhel7 will be installed
--> Processing Dependency: perl(:MODULE_COMPAT_5.16.3) for package: postgresql10-plperl-10.6-1PGDG.rhel7.x86_64
---> Package postgresql10-plpython.x86_64 0:10.6-1PGDG.rhel7 will be installed
---> Package postgresql10-pltcl.x86_64 0:10.6-1PGDG.rhel7 will be installed
--> Processing Dependency: tcl for package: postgresql10-pltcl-10.6-1PGDG.rhel7.x86_64
--> Processing Dependency: libtcl8.5.so()(64bit) for package: postgresql10-pltcl-10.6-1PGDG.rhel7.x86_64
---> Package postgresql10-server.x86_64 0:10.6-1PGDG.rhel7 will be installed
--> Running transaction check
---> Package libicu.x86_64 0:50.1.2-15.el7 will be installed
---> Package libxslt.x86_64 0:1.1.28-5.el7 will be installed
---> Package perl.x86_64 4:5.16.3-292.el7 will be installed
--> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl-macros for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(constant) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Time::HiRes) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Getopt::Long) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(File::Temp) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(File::Spec::Unix) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(File::Spec::Functions) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(File::Spec) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(File::Path) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Exporter) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Cwd) for package: 4:perl-5.16.3-292.el7.x86_64
--> Processing Dependency: perl(Carp) for package: 4:perl-5.16.3-292.el7.x86_64
---> Package perl-libs.x86_64 4:5.16.3-292.el7 will be installed
---> Package tcl.x86_64 1:8.5.13-8.el7 will be installed
--> 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-292.el7 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-292.el7 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

Dependencies Resolved

===========================================================================================
 Package                       Arch          Version                   Repository     Size
===========================================================================================
Installing:
 postgresql10                  x86_64        10.6-1PGDG.rhel7          pgdg10        1.6 M
 postgresql10-contrib          x86_64        10.6-1PGDG.rhel7          pgdg10        590 k
 postgresql10-libs             x86_64        10.6-1PGDG.rhel7          pgdg10        354 k
 postgresql10-plperl           x86_64        10.6-1PGDG.rhel7          pgdg10         58 k
 postgresql10-plpython         x86_64        10.6-1PGDG.rhel7          pgdg10         81 k
 postgresql10-pltcl            x86_64        10.6-1PGDG.rhel7          pgdg10         37 k
 postgresql10-server           x86_64        10.6-1PGDG.rhel7          pgdg10        4.6 M
Installing for dependencies:
 libicu                        x86_64        50.1.2-15.el7             base          6.9 M
 libxslt                       x86_64        1.1.28-5.el7              base          242 k
 perl                          x86_64        4:5.16.3-292.el7          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-292.el7            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-292.el7          base          688 k
 perl-macros                   x86_64        4:5.16.3-292.el7          base           43 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
 tcl                           x86_64        1:8.5.13-8.el7            base          1.9 M

Transaction Summary
===========================================================================================
Install  7 Packages (+30 Dependent packages)

Total download size: 28 M
Installed size: 95 M
Is this ok [y/d/N]: y
Downloading packages:
(1/37): perl-Carp-1.26-244.el7.noarch.rpm                           |  19 kB  00:00:00     
(2/37): libxslt-1.1.28-5.el7.x86_64.rpm                             | 242 kB  00:00:00     
(3/37): perl-Exporter-5.68-3.el7.noarch.rpm                         |  28 kB  00:00:00     
(4/37): perl-File-Temp-0.23.01-3.el7.noarch.rpm                     |  56 kB  00:00:00     
(5/37): perl-Filter-1.49-3.el7.x86_64.rpm                           |  76 kB  00:00:00     
(6/37): perl-Getopt-Long-2.40-3.el7.noarch.rpm                      |  56 kB  00:00:00     
(7/37): perl-Encode-2.51-7.el7.x86_64.rpm                           | 1.5 MB  00:00:01     
(8/37): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm                       |  38 kB  00:00:00     
(9/37): perl-PathTools-3.40-5.el7.x86_64.rpm                        |  82 kB  00:00:00     
(10/37): perl-Pod-Escapes-1.04-292.el7.noarch.rpm                   |  51 kB  00:00:00     
(11/37): perl-Pod-Simple-3.28-4.el7.noarch.rpm                      | 216 kB  00:00:00     
(12/37): perl-Pod-Usage-1.63-3.el7.noarch.rpm                       |  27 kB  00:00:00     
(13/37): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm             |  36 kB  00:00:00     
(14/37): perl-5.16.3-292.el7.x86_64.rpm                             | 8.0 MB  00:00:02     
(15/37): perl-Storable-2.45-3.el7.x86_64.rpm                        |  77 kB  00:00:00     
(16/37): perl-Socket-2.010-4.el7.x86_64.rpm                         |  49 kB  00:00:00     
(17/37): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm                     |  87 kB  00:00:00     
(18/37): perl-Text-ParseWords-3.29-4.el7.noarch.rpm                 |  14 kB  00:00:00     
(19/37): perl-Time-Local-1.2300-2.el7.noarch.rpm                    |  24 kB  00:00:00     
(20/37): perl-constant-1.27-2.el7.noarch.rpm                        |  19 kB  00:00:00     
(21/37): perl-libs-5.16.3-292.el7.x86_64.rpm                        | 688 kB  00:00:00     
(22/37): perl-macros-5.16.3-292.el7.x86_64.rpm                      |  43 kB  00:00:00     
(23/37): perl-Time-HiRes-1.9725-3.el7.x86_64.rpm                    |  45 kB  00:00:00     
(24/37): perl-parent-0.225-244.el7.noarch.rpm                       |  12 kB  00:00:00     
(25/37): perl-threads-1.87-4.el7.x86_64.rpm                         |  49 kB  00:00:00     
(26/37): perl-threads-shared-1.43-6.el7.x86_64.rpm                  |  39 kB  00:00:00     
(27/37): perl-podlators-2.5.1-3.el7.noarch.rpm                      | 112 kB  00:00:00     
(28/37): libicu-50.1.2-15.el7.x86_64.rpm                            | 6.9 MB  00:00:03     
(29/37): postgresql10-contrib-10.6-1PGDG.rhel7.x86_64.rpm           | 590 kB  00:00:03     
(30/37): postgresql10-libs-10.6-1PGDG.rhel7.x86_64.rpm              | 354 kB  00:00:01     
(31/37): postgresql10-plperl-10.6-1PGDG.rhel7.x86_64.rpm            |  58 kB  00:00:00     
(32/37): postgresql10-10.6-1PGDG.rhel7.x86_64.rpm                   | 1.6 MB  00:00:05     
(33/37): postgresql10-plpython-10.6-1PGDG.rhel7.x86_64.rpm          |  81 kB  00:00:00     
(34/37): postgresql10-pltcl-10.6-1PGDG.rhel7.x86_64.rpm             |  37 kB  00:00:00     
(35/37): tcl-8.5.13-8.el7.x86_64.rpm                                | 1.9 MB  00:00:00     
(36/37): postgresql10-server-10.6-1PGDG.rhel7.x86_64.rpm            | 4.6 MB  00:00:06     
perl-File-Path-2.09-2.el7.noar FAILED                                          
http://mirrors.njupt.edu.cn/centos/7.5.1804/os/x86_64/Packages/perl-File-Path-2.09-2.el7.noarch.rpm: [Errno 12] Timeout on http://10.10.254.10/cache/4/01/mirrors.njupt.edu.cn/7b74215f0436e2c79988e442a0d2acf8/perl-File-Path-2.09-2.el7.noarch.rpm: (28, 'Connection timed out after 30947 milliseconds')
Trying other mirror.
(37/37): perl-File-Path-2.09-2.el7.noarch.rpm                       |  26 kB  00:00:00     
-------------------------------------------------------------------------------------------
Total                                                      870 kB/s |  28 MB  00:00:32     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : postgresql10-libs-10.6-1PGDG.rhel7.x86_64                              1/37 
  Installing : libicu-50.1.2-15.el7.x86_64                                            2/37 
  Installing : postgresql10-10.6-1PGDG.rhel7.x86_64                                   3/37 
  Installing : postgresql10-server-10.6-1PGDG.rhel7.x86_64                            4/37 
  Installing : 1:perl-parent-0.225-244.el7.noarch                                     5/37 
  Installing : perl-HTTP-Tiny-0.033-3.el7.noarch                                      6/37 
  Installing : perl-podlators-2.5.1-3.el7.noarch                                      7/37 
  Installing : perl-Pod-Perldoc-3.20-4.el7.noarch                                     8/37 
  Installing : 1:perl-Pod-Escapes-1.04-292.el7.noarch                                 9/37 
  Installing : perl-Text-ParseWords-3.29-4.el7.noarch                                10/37 
  Installing : perl-Encode-2.51-7.el7.x86_64                                         11/37 
  Installing : perl-Pod-Usage-1.63-3.el7.noarch                                      12/37 
  Installing : 4:perl-macros-5.16.3-292.el7.x86_64                                   13/37 
  Installing : 4:perl-libs-5.16.3-292.el7.x86_64                                     14/37 
  Installing : perl-Storable-2.45-3.el7.x86_64                                       15/37 
  Installing : perl-Exporter-5.68-3.el7.noarch                                       16/37 
  Installing : perl-constant-1.27-2.el7.noarch                                       17/37 
  Installing : perl-Time-Local-1.2300-2.el7.noarch                                   18/37 
  Installing : perl-Socket-2.010-4.el7.x86_64                                        19/37 
  Installing : perl-Carp-1.26-244.el7.noarch                                         20/37 
  Installing : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                 21/37 
  Installing : perl-PathTools-3.40-5.el7.x86_64                                      22/37 
  Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64                            23/37 
  Installing : perl-File-Temp-0.23.01-3.el7.noarch                                   24/37 
  Installing : perl-File-Path-2.09-2.el7.noarch                                      25/37 
  Installing : perl-threads-shared-1.43-6.el7.x86_64                                 26/37 
  Installing : perl-threads-1.87-4.el7.x86_64                                        27/37 
  Installing : perl-Filter-1.49-3.el7.x86_64                                         28/37 
  Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch                                   29/37 
  Installing : perl-Getopt-Long-2.40-3.el7.noarch                                    30/37 
  Installing : 4:perl-5.16.3-292.el7.x86_64                                          31/37 
  Installing : libxslt-1.1.28-5.el7.x86_64                                           32/37 
  Installing : 1:tcl-8.5.13-8.el7.x86_64                                             33/37 
  Installing : postgresql10-pltcl-10.6-1PGDG.rhel7.x86_64                            34/37 
  Installing : postgresql10-contrib-10.6-1PGDG.rhel7.x86_64                          35/37 
  Installing : postgresql10-plperl-10.6-1PGDG.rhel7.x86_64                           36/37 
  Installing : postgresql10-plpython-10.6-1PGDG.rhel7.x86_64                         37/37 
  Verifying  : perl-HTTP-Tiny-0.033-3.el7.noarch                                      1/37 
  Verifying  : 1:tcl-8.5.13-8.el7.x86_64                                              2/37 
  Verifying  : perl-threads-shared-1.43-6.el7.x86_64                                  3/37 
  Verifying  : perl-Storable-2.45-3.el7.x86_64                                        4/37 
  Verifying  : perl-Exporter-5.68-3.el7.noarch                                        5/37 
  Verifying  : perl-constant-1.27-2.el7.noarch                                        6/37 
  Verifying  : perl-PathTools-3.40-5.el7.x86_64                                       7/37 
  Verifying  : 4:perl-macros-5.16.3-292.el7.x86_64                                    8/37 
  Verifying  : 1:perl-parent-0.225-244.el7.noarch                                     9/37 
  Verifying  : 4:perl-5.16.3-292.el7.x86_64                                          10/37 
  Verifying  : postgresql10-libs-10.6-1PGDG.rhel7.x86_64                             11/37 
  Verifying  : perl-File-Temp-0.23.01-3.el7.noarch                                   12/37 
  Verifying  : 1:perl-Pod-Simple-3.28-4.el7.noarch                                   13/37 
  Verifying  : perl-Getopt-Long-2.40-3.el7.noarch                                    14/37 
  Verifying  : perl-Time-Local-1.2300-2.el7.noarch                                   15/37 
  Verifying  : 4:perl-libs-5.16.3-292.el7.x86_64                                     16/37 
  Verifying  : perl-Socket-2.010-4.el7.x86_64                                        17/37 
  Verifying  : perl-Carp-1.26-244.el7.noarch                                         18/37 
  Verifying  : postgresql10-contrib-10.6-1PGDG.rhel7.x86_64                          19/37 
  Verifying  : libxslt-1.1.28-5.el7.x86_64                                           20/37 
  Verifying  : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                 21/37 
  Verifying  : postgresql10-plperl-10.6-1PGDG.rhel7.x86_64                           22/37 
  Verifying  : perl-Scalar-List-Utils-1.27-248.el7.x86_64                            23/37 
  Verifying  : 1:perl-Pod-Escapes-1.04-292.el7.noarch                                24/37 
  Verifying  : postgresql10-plpython-10.6-1PGDG.rhel7.x86_64                         25/37 
  Verifying  : perl-Pod-Usage-1.63-3.el7.noarch                                      26/37 
  Verifying  : postgresql10-pltcl-10.6-1PGDG.rhel7.x86_64                            27/37 
  Verifying  : perl-Encode-2.51-7.el7.x86_64                                         28/37 
  Verifying  : perl-Pod-Perldoc-3.20-4.el7.noarch                                    29/37 
  Verifying  : perl-podlators-2.5.1-3.el7.noarch                                     30/37 
  Verifying  : perl-File-Path-2.09-2.el7.noarch                                      31/37 
  Verifying  : libicu-50.1.2-15.el7.x86_64                                           32/37 
  Verifying  : perl-threads-1.87-4.el7.x86_64                                        33/37 
  Verifying  : perl-Filter-1.49-3.el7.x86_64                                         34/37 
  Verifying  : postgresql10-10.6-1PGDG.rhel7.x86_64                                  35/37 
  Verifying  : perl-Text-ParseWords-3.29-4.el7.noarch                                36/37 
  Verifying  : postgresql10-server-10.6-1PGDG.rhel7.x86_64                           37/37 

Installed:
  postgresql10.x86_64 0:10.6-1PGDG.rhel7                                                   
  postgresql10-contrib.x86_64 0:10.6-1PGDG.rhel7                                           
  postgresql10-libs.x86_64 0:10.6-1PGDG.rhel7                                              
  postgresql10-plperl.x86_64 0:10.6-1PGDG.rhel7                                            
  postgresql10-plpython.x86_64 0:10.6-1PGDG.rhel7                                          
  postgresql10-pltcl.x86_64 0:10.6-1PGDG.rhel7                                             
  postgresql10-server.x86_64 0:10.6-1PGDG.rhel7                                            

Dependency Installed:
  libicu.x86_64 0:50.1.2-15.el7                  libxslt.x86_64 0:1.1.28-5.el7             
  perl.x86_64 4:5.16.3-292.el7                   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-292.el7         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-292.el7         
  perl-macros.x86_64 4:5.16.3-292.el7            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        tcl.x86_64 1:8.5.13-8.el7                 

Complete!

三、初始化數(shù)據(jù)庫

數(shù)據(jù)目錄在 /data/pg10data

方法一：使用postgresql-10-setup 初始化數(shù)據(jù)庫

postgresql-10-setup 自動創(chuàng)建
用戶組：postgres
用戶：postgres

mkdir /data/pg10data  
chmod 700 /data/pg10data
chown postgres:postgres /data/pg10data
vi /usr/lib/systemd/system/postgresql-10.service
把Environment=PGDATA=/var/lib/pgsql/10/data/修改為Environment=PGDATA=/data/pg10data/

/usr/pgsql-10/bin/postgresql-10-setup initdb   #初始化
systemctl enable postgresql-10                 #設(shè)置開機啟動    
systemctl start postgresql-10                  #啟動postgresql服務(wù) 

# centos6 的開機啟動
chkconfig postgresql-10 on   #設(shè)置開機啟動    
service postgresql-10 start #啟動postgresql服務(wù)

方法二：使用 initdb 初始化數(shù)據(jù)庫

數(shù)據(jù)目錄在 /data/pg10data

#新增postgres用戶組：
groupadd postgres

#新增postgres用戶并且設(shè)置這個用戶屬于上面創(chuàng)建的postgres用戶組：
useradd -g postgres postgres

#修改postgres用戶密碼:passwd postgres（這里設(shè)置密碼為postgres）
passwd postgres  --修改postgres用戶密碼

mkdir /data/pg10data  
chmod 700 /data/pg10data
chown postgres:postgres /data/pg10data

su - postgres
#初始化數(shù)據(jù)庫
$/usr/pgsql-10/bin/initdb --encoding=UTF-8 --local=zh_CN.UTF8 --pgdata=/data/pg10data/
啟動
$/usr/pgsql-10/bin/pg_ctl -D /data/pg10data/ -l /data/pg10data/log/db.log start
停止
$/usr/pgsql-10/bin/pg_ctl -D /data/pg10data/ -l /data/pg10data/log/db.log stop
#寫入系統(tǒng)啟動項
$echo "su - postgres -c '/usr/pgsql-10/bin/pg_ctl -D /data/pg10data/ -l /data/pg10data/log/db.log start'" >> /etc/rc.d/rc.local
$chmod +x /etc/rc.d/rc.local

登錄postgresql并設(shè)置密碼

設(shè)置用戶 postgres 密碼 postgres

su - postgres
psql
ALTER USER postgres WITH PASSWORD 'postgres';

數(shù)據(jù)庫登錄權(quán)限設(shè)置

開啟遠程訪問

vi /data/pg10data/postgresql.conf 
修改#listen_addresses = ‘localhost’ 為 listen_addresses=’*’ 
當然橄唬，此處‘*’也可以改為任何你想開放的服務(wù)器IP

如有需要修改端口

vi/data/pg10data/postgresql.conf 
修改#port =5432 為 port =端口

image.png

信任遠程連接

vi /data/pg10data/pg_hba.conf 
修改如下內(nèi)容赋焕，信任指定服務(wù)器連接 
# IPv4 local connections: 
host    all             all             127.0.0.1/32            trust
host    all             all             0.0.0.0/0            password

image.png

打開防火墻

CentOS 防火墻中內(nèi)置了PostgreSQL服務(wù)，配置文件位置在/usr/lib/firewalld/services/postgresql.xml轧坎，我們只需以服務(wù)方式將PostgreSQL服務(wù)開放即可宏邮。

 #開機啟用防火墻
systemctl enable firewalld

 #開啟防火墻
systemctl start firewalld

#開放postgresql服務(wù)
firewall-cmd --add-service=postgresql --permanent 

#或者可以直接添加端口
firewall-cmd --zone=public --add-port=5432/tcp --permanent 

#重載防火墻
firewall-cmd --reload  

#查看占用端口
firewall-cmd --list-ports

測試使用

因為postgres屬于superuser，我們需要創(chuàng)建部分低權(quán)限用戶

創(chuàng)建數(shù)據(jù)庫

CREATE DATABASE testdb;
創(chuàng)建用戶

CREATE USER testuser CREATEDB LOGIN PASSWORD 'testpassword';
將testdb所有權(quán)限賦給用戶testuser

GRANT ALL ON DATABASE testdb TO testuser;

刪除數(shù)據(jù)庫

drop database testdb;

刪除用戶

drop role testuser;

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者

人面猴
序言：七十年代末缸血，一起剝皮案震驚了整個濱河市蜜氨，隨后出現(xiàn)的幾起案子，更是在濱河造成了極大的恐慌捎泻，老刑警劉巖飒炎，帶你破解...
沈念sama閱讀 217,185評論 6贊 503
死咒
序言：濱河連續(xù)發(fā)生了三起死亡事件，死亡現(xiàn)場離奇詭異笆豁，居然都是意外死亡郎汪，警方通過查閱死者的電腦和手機，發(fā)現(xiàn)死者居然都...
沈念sama閱讀 92,652評論 3贊 393
救了他兩次的神仙讓他今天三更去死
文/潘曉璐我一進店門闯狱，熙熙樓的掌柜王于貴愁眉苦臉地迎上來煞赢，“玉大人，你說我怎么就攤上這事哄孤≌罩” “怎么了？”我有些...
開封第一講書人閱讀 163,524評論 0贊 353
道士緝兇錄：失蹤的賣姜人
文/不壞的土叔我叫張陵瘦陈，是天一觀的道長凝危。經(jīng)常有香客問我，道長晨逝，這世上最難降的妖魔是什么蛾默？我笑而不...
開封第一講書人閱讀 58,339評論 1贊 293
?港島之戀（遺憾婚禮）
正文為了忘掉前任，我火速辦了婚禮捉貌，結(jié)果婚禮上支鸡，老公的妹妹穿的比我還像新娘冬念。我一直安慰自己，他們只是感情好牧挣，可當我...
茶點故事閱讀 67,387評論 6贊 391
惡毒庶女頂嫁案：這布局不是一般人想出來的
文/花漫我一把揭開白布刘急。她就那樣靜靜地躺著，像睡著了一般浸踩。火紅的嫁衣襯著肌膚如雪。梳的紋絲不亂的頭發(fā)上统求，一...
開封第一講書人閱讀 51,287評論 1贊 301
城市分裂傳說
那天检碗，我揣著相機與錄音，去河邊找鬼码邻。笑死折剃，一個胖子當著我的面吹牛，可吹牛的內(nèi)容都是我干的像屋。我是一名探鬼主播怕犁，決...
沈念sama閱讀 40,130評論 3贊 418
雙鴛鴦連環(huán)套：你想象不到人心有多黑
文/蒼蘭香墨我猛地睜開眼，長吁一口氣：“原來是場噩夢啊……” “哼己莺！你這毒婦竟也來了奏甫？” 一聲冷哼從身側(cè)響起，我...
開封第一講書人閱讀 38,985評論 0贊 275
萬榮殺人案實錄
序言：老撾萬榮一對情侶失蹤凌受，失蹤者是張志新（化名）和其女友劉穎阵子，沒想到半個月后，有當?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體胜蛉，經(jīng)...
沈念sama閱讀 45,420評論 1贊 313
?護林員之死
正文獨居荒郊野嶺守林人離奇死亡挠进，尸身上長有42處帶血的膿包…… 初始之章·張勛以下內(nèi)容為張勛視角年9月15日...
茶點故事閱讀 37,617評論 3贊 334
?白月光啟示錄
正文我和宋清朗相戀三年，在試婚紗的時候發(fā)現(xiàn)自己被綠了誊册。大學(xué)時的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片领突。...
茶點故事閱讀 39,779評論 1贊 348
活死人
序言：一個原本活蹦亂跳的男人離奇死亡，死狀恐怖案怯，靈堂內(nèi)的尸體忽然破棺而出君旦，到底是詐尸還是另有隱情，我是刑警寧澤殴泰，帶...
沈念sama閱讀 35,477評論 5贊 345
?日本核電站爆炸內(nèi)幕
正文年R本政府宣布于宙，位于F島的核電站，受9級特大地震影響悍汛，放射性物質(zhì)發(fā)生泄漏捞魁。R本人自食惡果不足惜，卻給世界環(huán)境...
茶點故事閱讀 41,088評論 3贊 328
男人毒藥：我在死后第九天來索命
文/蒙蒙一离咐、第九天我趴在偏房一處隱蔽的房頂上張望谱俭。院中可真熱鬧奉件，春花似錦、人聲如沸昆著。這莊子的主人今日做“春日...
開封第一講書人閱讀 31,716評論 0贊 22
一樁弒父案，背后竟有這般陰謀
文/蒼蘭香墨我抬頭看了看天上的太陽凑懂。三九已至煤痕，卻和暖如春，著一層夾襖步出監(jiān)牢的瞬間接谨，已是汗流浹背摆碉。一陣腳步聲響...
開封第一講書人閱讀 32,857評論 1贊 269
情欲美人皮
我被黑心中介騙來泰國打工，沒想到剛下飛機就差點兒被人妖公主榨干…… 1. 我叫王不留脓豪，地道東北人巷帝。一個月前我還...
沈念sama閱讀 47,876評論 2贊 370
代替公主和親
正文我出身青樓，卻偏偏與公主長得像扫夜，于是被迫代替她去往敵國和親楞泼。傳聞我的和親對象是個殘疾皇子，可洞房花燭夜當晚...
茶點故事閱讀 44,700評論 2贊 354