Edited at

How to install Postgresql 9.x on CentOS 7.x

More than 1 year has passed since last update.


step by step


  • check SE Linux

# getenforce

Disabled
# sestatus
SELinux status: disabled


  • yum group install

# yum -y groupinstall base "Development tools"

Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* epel: ftp.riken.jp
* epel-debuginfo: ftp.riken.jp
* epel-source: ftp.riken.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
Resolving Dependencies
--> Running transaction check
---> Package autoconf.noarch 0:2.69-11.el7 will be installed
--> Processing Dependency: m4 >= 1.4.14 for package: autoconf-2.69-11.el7.noarch
--> Processing Dependency: perl(Data::Dumper) for package: autoconf-2.69-11.el7.noarch
---> Package automake.noarch 0:1.13.4-3.el7 will be installed
--> Processing Dependency: perl(Thread::Queue) for package: automake-1.13.4-3.el7.noarch
--> Processing Dependency: perl(TAP::Parser) for package: automake-1.13.4-3.el7.noarch
---> Package bison.x86_64 0:2.7-4.el7 will be installed
---> Package byacc.x86_64 0:1.9.20130304-3.el7 will be installed
---> Package cscope.x86_64 0:15.8-9.el7 will be installed
---> Package ctags.x86_64 0:5.8-13.el7 will be installed
---> Package diffstat.x86_64 0:1.57-4.el7 will be installed
---> Package doxygen.x86_64 1:1.8.5-3.el7 will be installed
---> Package flex.x86_64 0:2.5.37-3.el7 will be installed
---> Package gcc.x86_64 0:4.8.5-11.el7 will be installed
--> Processing Dependency: cpp = 4.8.5-11.el7 for package: gcc-4.8.5-11.el7.x86_64
--> Processing Dependency: glibc-devel >= 2.2.90-12 for package: gcc-4.8.5-11.el7.x86_64
--> Processing Dependency: libmpfr.so.4()(64bit) for package: gcc-4.8.5-11.el7.x86_64
--> Processing Dependency: libmpc.so.3()(64bit) for package: gcc-4.8.5-11.el7.x86_64
---> Package gcc-c++.x86_64 0:4.8.5-11.el7 will be installed
--> Processing Dependency: libstdc++-devel = 4.8.5-11.el7 for package: gcc-c++-4.8.5-11.el7.x86_64
---> Package gcc-gfortran.x86_64 0:4.8.5-11.el7 will be installed
--> Processing Dependency: libquadmath-devel = 4.8.5-11.el7 for package: gcc-gfortran-4.8.5-11.el7.x86_64
--> Processing Dependency: libquadmath = 4.8.5-11.el7 for package: gcc-gfortran-4.8.5-11.el7.x86_64
--> Processing Dependency: libgfortran = 4.8.5-11.el7 for package: gcc-gfortran-4.8.5-11.el7.x86_64
--> Processing Dependency: libgfortran.so.3()(64bit) for package: gcc-gfortran-4.8.5-11.el7.x86_64
---> Package git.x86_64 0:1.8.3.1-6.el7_2.1 will be installed
--> Processing Dependency: perl-Git = 1.8.3.1-6.el7_2.1 for package: git-1.8.3.1-6.el7_2.1.x86_64
--> Processing Dependency: perl(Term::ReadKey) for package: git-1.8.3.1-6.el7_2.1.x86_64
--> Processing Dependency: perl(Git) for package: git-1.8.3.1-6.el7_2.1.x86_64
--> Processing Dependency: perl(Error) for package: git-1.8.3.1-6.el7_2.1.x86_64
--> Processing Dependency: libgnome-keyring.so.0()(64bit) for package: git-1.8.3.1-6.el7_2.1.x86_64
---> Package indent.x86_64 0:2.2.11-13.el7 will be installed
---> Package intltool.noarch 0:0.50.2-6.el7 will be installed
--> Processing Dependency: perl(XML::Parser) for package: intltool-0.50.2-6.el7.noarch
--> Processing Dependency: gettext-devel for package: intltool-0.50.2-6.el7.noarch
---> Package libtool.x86_64 0:2.4.2-21.el7_2 will be installed
---> Package patch.x86_64 0:2.7.1-8.el7 will be installed
---> Package patchutils.x86_64 0:0.3.3-4.el7 will be installed
---> Package rcs.x86_64 0:5.9.0-5.el7 will be installed
---> Package redhat-rpm-config.noarch 0:9.1.0-72.el7.centos will be installed
--> Processing Dependency: dwz >= 0.4 for package: redhat-rpm-config-9.1.0-72.el7.centos.noarch
--> Processing Dependency: perl-srpm-macros for package: redhat-rpm-config-9.1.0-72.el7.centos.noarch
---> Package rpm-build.x86_64 0:4.11.3-21.el7 will be installed
---> Package rpm-sign.x86_64 0:4.11.3-21.el7 will be installed
---> Package subversion.x86_64 0:1.7.14-10.el7 will be installed
--> Processing Dependency: subversion-libs(x86-64) = 1.7.14-10.el7 for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_wc-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_subr-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_repos-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_ra_svn-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_ra_neon-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_ra_local-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_ra-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_fs_util-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_fs_fs-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_fs_base-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_fs-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_diff-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_delta-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libsvn_client-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libneon.so.27()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libaprutil-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
--> Processing Dependency: libapr-1.so.0()(64bit) for package: subversion-1.7.14-10.el7.x86_64
---> Package swig.x86_64 0:2.0.10-5.el7 will be installed
---> Package systemtap.x86_64 0:3.0-7.el7 will be installed
--> Processing Dependency: systemtap-devel = 3.0-7.el7 for package: systemtap-3.0-7.el7.x86_64
--> Processing Dependency: systemtap-client = 3.0-7.el7 for package: systemtap-3.0-7.el7.x86_64
--> Running transaction check
---> Package apr.x86_64 0:1.4.8-3.el7 will be installed
---> Package apr-util.x86_64 0:1.5.2-6.el7 will be installed
---> Package cpp.x86_64 0:4.8.5-11.el7 will be installed
---> Package dwz.x86_64 0:0.11-3.el7 will be installed
---> Package gettext-devel.x86_64 0:0.18.2.1-4.el7 will be installed
--> Processing Dependency: gettext-common-devel = 0.18.2.1-4.el7 for package: gettext-devel-0.18.2.1-4.el7.x86_64
---> Package glibc-devel.x86_64 0:2.17-157.el7_3.1 will be installed
--> Processing Dependency: glibc-headers = 2.17-157.el7_3.1 for package: glibc-devel-2.17-157.el7_3.1.x86_64
--> Processing Dependency: glibc-headers for package: glibc-devel-2.17-157.el7_3.1.x86_64
---> Package libgfortran.x86_64 0:4.8.5-11.el7 will be installed
---> Package libgnome-keyring.x86_64 0:3.8.0-3.el7 will be installed
---> Package libmpc.x86_64 0:1.0.1-3.el7 will be installed
---> Package libquadmath.x86_64 0:4.8.5-11.el7 will be installed
---> Package libquadmath-devel.x86_64 0:4.8.5-11.el7 will be installed
---> Package libstdc++-devel.x86_64 0:4.8.5-11.el7 will be installed
---> Package m4.x86_64 0:1.4.16-10.el7 will be installed
---> Package mpfr.x86_64 0:3.1.1-4.el7 will be installed
---> Package neon.x86_64 0:0.30.0-3.el7 will be installed
--> Processing Dependency: libpakchois.so.0()(64bit) for package: neon-0.30.0-3.el7.x86_64
---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed
---> Package perl-Error.noarch 1:0.17020-2.el7 will be installed
---> Package perl-Git.noarch 0:1.8.3.1-6.el7_2.1 will be installed
---> Package perl-TermReadKey.x86_64 0:2.30-20.el7 will be installed
---> Package perl-Test-Harness.noarch 0:3.28-3.el7 will be installed
---> Package perl-Thread-Queue.noarch 0:3.02-2.el7 will be installed
---> Package perl-XML-Parser.x86_64 0:2.41-10.el7 will be installed
---> Package perl-srpm-macros.noarch 0:1-8.el7 will be installed
---> Package subversion-libs.x86_64 0:1.7.14-10.el7 will be installed
---> Package systemtap-client.x86_64 0:3.0-7.el7 will be installed
--> Processing Dependency: mokutil for package: systemtap-client-3.0-7.el7.x86_64
--> Processing Dependency: libavahi-common.so.3()(64bit) for package: systemtap-client-3.0-7.el7.x86_64
--> Processing Dependency: libavahi-client.so.3()(64bit) for package: systemtap-client-3.0-7.el7.x86_64
---> Package systemtap-devel.x86_64 0:3.0-7.el7 will be installed
--> Processing Dependency: kernel-devel for package: systemtap-devel-3.0-7.el7.x86_64
--> Running transaction check
---> Package avahi-libs.x86_64 0:0.6.31-17.el7 will be installed
---> Package gettext-common-devel.noarch 0:0.18.2.1-4.el7 will be installed
---> Package glibc-headers.x86_64 0:2.17-157.el7_3.1 will be installed
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.17-157.el7_3.1.x86_64
--> Processing Dependency: kernel-headers for package: glibc-headers-2.17-157.el7_3.1.x86_64
---> Package kernel-devel.x86_64 0:3.10.0-514.10.2.el7 will be installed
---> Package mokutil.x86_64 0:0.9-2.el7 will be installed
---> Package pakchois.x86_64 0:0.4-10.el7 will be installed
--> Running transaction check
---> Package kernel-headers.x86_64 0:3.10.0-514.10.2.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================
Package Arch Version Repository Size
=====================================================================================================================================================================
Installing for group install "Development Tools":
autoconf noarch 2.69-11.el7 base 701 k
automake noarch 1.13.4-3.el7 base 679 k
bison x86_64 2.7-4.el7 base 578 k
byacc x86_64 1.9.20130304-3.el7 base 65 k
cscope x86_64 15.8-9.el7 base 203 k
ctags x86_64 5.8-13.el7 base 155 k
diffstat x86_64 1.57-4.el7 base 35 k
doxygen x86_64 1:1.8.5-3.el7 base 3.6 M
flex x86_64 2.5.37-3.el7 base 292 k
gcc x86_64 4.8.5-11.el7 base 16 M
gcc-c++ x86_64 4.8.5-11.el7 base 7.2 M
gcc-gfortran x86_64 4.8.5-11.el7 base 6.6 M
git x86_64 1.8.3.1-6.el7_2.1 base 4.4 M
indent x86_64 2.2.11-13.el7 base 150 k
intltool noarch 0.50.2-6.el7 base 59 k
libtool x86_64 2.4.2-21.el7_2 base 588 k
patch x86_64 2.7.1-8.el7 base 110 k
patchutils x86_64 0.3.3-4.el7 base 104 k
rcs x86_64 5.9.0-5.el7 base 230 k
redhat-rpm-config noarch 9.1.0-72.el7.centos base 78 k
rpm-build x86_64 4.11.3-21.el7 base 145 k
rpm-sign x86_64 4.11.3-21.el7 base 45 k
subversion x86_64 1.7.14-10.el7 base 1.0 M
swig x86_64 2.0.10-5.el7 base 1.3 M
systemtap x86_64 3.0-7.el7 base 145 k
Installing for dependencies:
apr x86_64 1.4.8-3.el7 base 103 k
apr-util x86_64 1.5.2-6.el7 base 92 k
avahi-libs x86_64 0.6.31-17.el7 base 61 k
cpp x86_64 4.8.5-11.el7 base 5.9 M
dwz x86_64 0.11-3.el7 base 99 k
gettext-common-devel noarch 0.18.2.1-4.el7 base 368 k
gettext-devel x86_64 0.18.2.1-4.el7 base 315 k
glibc-devel x86_64 2.17-157.el7_3.1 updates 1.1 M
glibc-headers x86_64 2.17-157.el7_3.1 updates 668 k
kernel-devel x86_64 3.10.0-514.10.2.el7 updates 13 M
kernel-headers x86_64 3.10.0-514.10.2.el7 updates 4.8 M
libgfortran x86_64 4.8.5-11.el7 base 295 k
libgnome-keyring x86_64 3.8.0-3.el7 base 109 k
libmpc x86_64 1.0.1-3.el7 base 51 k
libquadmath x86_64 4.8.5-11.el7 base 184 k
libquadmath-devel x86_64 4.8.5-11.el7 base 47 k
libstdc++-devel x86_64 4.8.5-11.el7 base 1.5 M
m4 x86_64 1.4.16-10.el7 base 256 k
mokutil x86_64 0.9-2.el7 base 37 k
mpfr x86_64 3.1.1-4.el7 base 203 k
neon x86_64 0.30.0-3.el7 base 165 k
pakchois x86_64 0.4-10.el7 base 14 k
perl-Data-Dumper x86_64 2.145-3.el7 base 47 k
perl-Error noarch 1:0.17020-2.el7 base 32 k
perl-Git noarch 1.8.3.1-6.el7_2.1 base 53 k
perl-TermReadKey x86_64 2.30-20.el7 base 31 k
perl-Test-Harness noarch 3.28-3.el7 base 302 k
perl-Thread-Queue noarch 3.02-2.el7 base 17 k
perl-XML-Parser x86_64 2.41-10.el7 base 223 k
perl-srpm-macros noarch 1-8.el7 base 4.6 k
subversion-libs x86_64 1.7.14-10.el7 base 921 k
systemtap-client x86_64 3.0-7.el7 base 3.5 M
systemtap-devel x86_64 3.0-7.el7 base 1.8 M

Transaction Summary
=====================================================================================================================================================================
Install 25 Packages (+33 Dependent packages)

Total download size: 81 M
Installed size: 217 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
(1/58): apr-1.4.8-3.el7.x86_64.rpm | 103 kB 00:00:00
(2/58): apr-util-1.5.2-6.el7.x86_64.rpm | 92 kB 00:00:00
(3/58): autoconf-2.69-11.el7.noarch.rpm | 701 kB 00:00:00
(4/58): automake-1.13.4-3.el7.noarch.rpm | 679 kB 00:00:00
(5/58): avahi-libs-0.6.31-17.el7.x86_64.rpm | 61 kB 00:00:00
(6/58): bison-2.7-4.el7.x86_64.rpm | 578 kB 00:00:00
(7/58): byacc-1.9.20130304-3.el7.x86_64.rpm | 65 kB 00:00:00
(8/58): cscope-15.8-9.el7.x86_64.rpm | 203 kB 00:00:00
(9/58): ctags-5.8-13.el7.x86_64.rpm | 155 kB 00:00:00
(10/58): cpp-4.8.5-11.el7.x86_64.rpm | 5.9 MB 00:00:00
(11/58): diffstat-1.57-4.el7.x86_64.rpm | 35 kB 00:00:00
(12/58): dwz-0.11-3.el7.x86_64.rpm | 99 kB 00:00:00
(13/58): flex-2.5.37-3.el7.x86_64.rpm | 292 kB 00:00:00
(14/58): doxygen-1.8.5-3.el7.x86_64.rpm | 3.6 MB 00:00:00
(15/58): gcc-4.8.5-11.el7.x86_64.rpm | 16 MB 00:00:00
(16/58): gcc-c++-4.8.5-11.el7.x86_64.rpm | 7.2 MB 00:00:00
(17/58): gettext-common-devel-0.18.2.1-4.el7.noarch.rpm | 368 kB 00:00:00
(18/58): gettext-devel-0.18.2.1-4.el7.x86_64.rpm | 315 kB 00:00:00
(19/58): gcc-gfortran-4.8.5-11.el7.x86_64.rpm | 6.6 MB 00:00:00
(20/58): indent-2.2.11-13.el7.x86_64.rpm | 150 kB 00:00:00
(21/58): git-1.8.3.1-6.el7_2.1.x86_64.rpm | 4.4 MB 00:00:00
(22/58): intltool-0.50.2-6.el7.noarch.rpm | 59 kB 00:00:00
(23/58): glibc-devel-2.17-157.el7_3.1.x86_64.rpm | 1.1 MB 00:00:00
(24/58): glibc-headers-2.17-157.el7_3.1.x86_64.rpm | 668 kB 00:00:00
(25/58): libgnome-keyring-3.8.0-3.el7.x86_64.rpm | 109 kB 00:00:00
(26/58): libmpc-1.0.1-3.el7.x86_64.rpm | 51 kB 00:00:00
(27/58): libgfortran-4.8.5-11.el7.x86_64.rpm | 295 kB 00:00:00
(28/58): libquadmath-devel-4.8.5-11.el7.x86_64.rpm | 47 kB 00:00:00
(29/58): libquadmath-4.8.5-11.el7.x86_64.rpm | 184 kB 00:00:00
(30/58): libtool-2.4.2-21.el7_2.x86_64.rpm | 588 kB 00:00:00
(31/58): m4-1.4.16-10.el7.x86_64.rpm | 256 kB 00:00:00
(32/58): mokutil-0.9-2.el7.x86_64.rpm | 37 kB 00:00:00
(33/58): mpfr-3.1.1-4.el7.x86_64.rpm | 203 kB 00:00:00
(34/58): neon-0.30.0-3.el7.x86_64.rpm | 165 kB 00:00:00
(35/58): pakchois-0.4-10.el7.x86_64.rpm | 14 kB 00:00:00
(36/58): patch-2.7.1-8.el7.x86_64.rpm | 110 kB 00:00:00
(37/58): kernel-headers-3.10.0-514.10.2.el7.x86_64.rpm | 4.8 MB 00:00:01
(38/58): patchutils-0.3.3-4.el7.x86_64.rpm | 104 kB 00:00:00
(39/58): perl-Data-Dumper-2.145-3.el7.x86_64.rpm | 47 kB 00:00:00
(40/58): perl-Error-0.17020-2.el7.noarch.rpm | 32 kB 00:00:00
(41/58): perl-Git-1.8.3.1-6.el7_2.1.noarch.rpm | 53 kB 00:00:00
(42/58): perl-TermReadKey-2.30-20.el7.x86_64.rpm | 31 kB 00:00:00
(43/58): perl-Test-Harness-3.28-3.el7.noarch.rpm | 302 kB 00:00:00
(44/58): perl-Thread-Queue-3.02-2.el7.noarch.rpm | 17 kB 00:00:00
(45/58): perl-XML-Parser-2.41-10.el7.x86_64.rpm | 223 kB 00:00:00
(46/58): perl-srpm-macros-1-8.el7.noarch.rpm | 4.6 kB 00:00:00
(47/58): rcs-5.9.0-5.el7.x86_64.rpm | 230 kB 00:00:00
(48/58): redhat-rpm-config-9.1.0-72.el7.centos.noarch.rpm | 78 kB 00:00:00
(49/58): rpm-build-4.11.3-21.el7.x86_64.rpm | 145 kB 00:00:00
(50/58): rpm-sign-4.11.3-21.el7.x86_64.rpm | 45 kB 00:00:00
(51/58): libstdc++-devel-4.8.5-11.el7.x86_64.rpm | 1.5 MB 00:00:01
(52/58): subversion-1.7.14-10.el7.x86_64.rpm | 1.0 MB 00:00:00
(53/58): swig-2.0.10-5.el7.x86_64.rpm | 1.3 MB 00:00:00
(54/58): systemtap-3.0-7.el7.x86_64.rpm | 145 kB 00:00:00
(55/58): kernel-devel-3.10.0-514.10.2.el7.x86_64.rpm | 13 MB 00:00:02
(56/58): subversion-libs-1.7.14-10.el7.x86_64.rpm | 921 kB 00:00:00
(57/58): systemtap-client-3.0-7.el7.x86_64.rpm | 3.5 MB 00:00:00
(58/58): systemtap-devel-3.0-7.el7.x86_64.rpm | 1.8 MB 00:00:01
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 13 MB/s | 81 MB 00:00:06
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
Installing : mpfr-3.1.1-4.el7.x86_64 1/58
Installing : libmpc-1.0.1-3.el7.x86_64 2/58
Installing : apr-1.4.8-3.el7.x86_64 3/58
Installing : libquadmath-4.8.5-11.el7.x86_64 4/58
Installing : m4-1.4.16-10.el7.x86_64 5/58
Installing : apr-util-1.5.2-6.el7.x86_64 6/58
Installing : avahi-libs-0.6.31-17.el7.x86_64 7/58
Installing : 1:perl-Error-0.17020-2.el7.noarch 8/58
Installing : patch-2.7.1-8.el7.x86_64 9/58
Installing : perl-Thread-Queue-3.02-2.el7.noarch 10/58
Installing : libgfortran-4.8.5-11.el7.x86_64 11/58
Installing : cpp-4.8.5-11.el7.x86_64 12/58
Installing : libstdc++-devel-4.8.5-11.el7.x86_64 13/58
Installing : perl-srpm-macros-1-8.el7.noarch 14/58
Installing : pakchois-0.4-10.el7.x86_64 15/58
Installing : neon-0.30.0-3.el7.x86_64 16/58
Installing : subversion-libs-1.7.14-10.el7.x86_64 17/58
Installing : dwz-0.11-3.el7.x86_64 18/58
Installing : redhat-rpm-config-9.1.0-72.el7.centos.noarch 19/58
Installing : perl-Data-Dumper-2.145-3.el7.x86_64 20/58
Installing : autoconf-2.69-11.el7.noarch 21/58
Installing : gettext-common-devel-0.18.2.1-4.el7.noarch 22/58
Installing : perl-Test-Harness-3.28-3.el7.noarch 23/58
Installing : automake-1.13.4-3.el7.noarch 24/58
Installing : perl-TermReadKey-2.30-20.el7.x86_64 25/58
Installing : libgnome-keyring-3.8.0-3.el7.x86_64 26/58
Installing : perl-Git-1.8.3.1-6.el7_2.1.noarch 27/58
Installing : git-1.8.3.1-6.el7_2.1.x86_64 28/58
Installing : gettext-devel-0.18.2.1-4.el7.x86_64 29/58
Installing : kernel-devel-3.10.0-514.10.2.el7.x86_64 30/58
Installing : kernel-headers-3.10.0-514.10.2.el7.x86_64 31/58
Installing : glibc-headers-2.17-157.el7_3.1.x86_64 32/58
Installing : glibc-devel-2.17-157.el7_3.1.x86_64 33/58
Installing : gcc-4.8.5-11.el7.x86_64 34/58
Installing : libquadmath-devel-4.8.5-11.el7.x86_64 35/58
Installing : systemtap-devel-3.0-7.el7.x86_64 36/58
Installing : mokutil-0.9-2.el7.x86_64 37/58
Installing : systemtap-client-3.0-7.el7.x86_64 38/58
Installing : perl-XML-Parser-2.41-10.el7.x86_64 39/58
Installing : intltool-0.50.2-6.el7.noarch 40/58
Installing : systemtap-3.0-7.el7.x86_64 41/58
Installing : gcc-gfortran-4.8.5-11.el7.x86_64 42/58
Installing : gcc-c++-4.8.5-11.el7.x86_64 43/58
Installing : libtool-2.4.2-21.el7_2.x86_64 44/58
Installing : rpm-build-4.11.3-21.el7.x86_64 45/58
Installing : subversion-1.7.14-10.el7.x86_64 46/58
Installing : bison-2.7-4.el7.x86_64 47/58
Installing : flex-2.5.37-3.el7.x86_64 48/58
Installing : diffstat-1.57-4.el7.x86_64 49/58
Installing : patchutils-0.3.3-4.el7.x86_64 50/58
Installing : cscope-15.8-9.el7.x86_64 51/58
Installing : indent-2.2.11-13.el7.x86_64 52/58
Installing : swig-2.0.10-5.el7.x86_64 53/58
Installing : rcs-5.9.0-5.el7.x86_64 54/58
Installing : rpm-sign-4.11.3-21.el7.x86_64 55/58
Installing : 1:doxygen-1.8.5-3.el7.x86_64 56/58
Installing : byacc-1.9.20130304-3.el7.x86_64 57/58
Installing : ctags-5.8-13.el7.x86_64 58/58
Verifying : ctags-5.8-13.el7.x86_64 1/58
Verifying : gcc-c++-4.8.5-11.el7.x86_64 2/58
Verifying : systemtap-3.0-7.el7.x86_64 3/58
Verifying : perl-XML-Parser-2.41-10.el7.x86_64 4/58
Verifying : bison-2.7-4.el7.x86_64 5/58
Verifying : mokutil-0.9-2.el7.x86_64 6/58
Verifying : rpm-build-4.11.3-21.el7.x86_64 7/58
Verifying : kernel-headers-3.10.0-514.10.2.el7.x86_64 8/58
Verifying : byacc-1.9.20130304-3.el7.x86_64 9/58
Verifying : kernel-devel-3.10.0-514.10.2.el7.x86_64 10/58
Verifying : cpp-4.8.5-11.el7.x86_64 11/58
Verifying : automake-1.13.4-3.el7.noarch 12/58
Verifying : m4-1.4.16-10.el7.x86_64 13/58
Verifying : libgnome-keyring-3.8.0-3.el7.x86_64 14/58
Verifying : 1:doxygen-1.8.5-3.el7.x86_64 15/58
Verifying : glibc-headers-2.17-157.el7_3.1.x86_64 16/58
Verifying : redhat-rpm-config-9.1.0-72.el7.centos.noarch 17/58
Verifying : perl-TermReadKey-2.30-20.el7.x86_64 18/58
Verifying : rpm-sign-4.11.3-21.el7.x86_64 19/58
Verifying : perl-Test-Harness-3.28-3.el7.noarch 20/58
Verifying : subversion-1.7.14-10.el7.x86_64 21/58
Verifying : perl-Thread-Queue-3.02-2.el7.noarch 22/58
Verifying : systemtap-client-3.0-7.el7.x86_64 23/58
Verifying : libgfortran-4.8.5-11.el7.x86_64 24/58
Verifying : patch-2.7.1-8.el7.x86_64 25/58
Verifying : rcs-5.9.0-5.el7.x86_64 26/58
Verifying : swig-2.0.10-5.el7.x86_64 27/58
Verifying : 1:perl-Error-0.17020-2.el7.noarch 28/58
Verifying : glibc-devel-2.17-157.el7_3.1.x86_64 29/58
Verifying : gettext-common-devel-0.18.2.1-4.el7.noarch 30/58
Verifying : perl-Data-Dumper-2.145-3.el7.x86_64 31/58
Verifying : libquadmath-4.8.5-11.el7.x86_64 32/58
Verifying : perl-Git-1.8.3.1-6.el7_2.1.noarch 33/58
Verifying : indent-2.2.11-13.el7.x86_64 34/58
Verifying : apr-util-1.5.2-6.el7.x86_64 35/58
Verifying : flex-2.5.37-3.el7.x86_64 36/58
Verifying : libmpc-1.0.1-3.el7.x86_64 37/58
Verifying : cscope-15.8-9.el7.x86_64 38/58
Verifying : gettext-devel-0.18.2.1-4.el7.x86_64 39/58
Verifying : patchutils-0.3.3-4.el7.x86_64 40/58
Verifying : avahi-libs-0.6.31-17.el7.x86_64 41/58
Verifying : libquadmath-devel-4.8.5-11.el7.x86_64 42/58
Verifying : neon-0.30.0-3.el7.x86_64 43/58
Verifying : autoconf-2.69-11.el7.noarch 44/58
Verifying : intltool-0.50.2-6.el7.noarch 45/58
Verifying : systemtap-devel-3.0-7.el7.x86_64 46/58
Verifying : subversion-libs-1.7.14-10.el7.x86_64 47/58
Verifying : gcc-gfortran-4.8.5-11.el7.x86_64 48/58
Verifying : mpfr-3.1.1-4.el7.x86_64 49/58
Verifying : dwz-0.11-3.el7.x86_64 50/58
Verifying : libtool-2.4.2-21.el7_2.x86_64 51/58
Verifying : apr-1.4.8-3.el7.x86_64 52/58
Verifying : diffstat-1.57-4.el7.x86_64 53/58
Verifying : git-1.8.3.1-6.el7_2.1.x86_64 54/58
Verifying : pakchois-0.4-10.el7.x86_64 55/58
Verifying : gcc-4.8.5-11.el7.x86_64 56/58
Verifying : perl-srpm-macros-1-8.el7.noarch 57/58
Verifying : libstdc++-devel-4.8.5-11.el7.x86_64 58/58

Installed:
autoconf.noarch 0:2.69-11.el7 automake.noarch 0:1.13.4-3.el7 bison.x86_64 0:2.7-4.el7 byacc.x86_64 0:1.9.20130304-3.el7
cscope.x86_64 0:15.8-9.el7 ctags.x86_64 0:5.8-13.el7 diffstat.x86_64 0:1.57-4.el7 doxygen.x86_64 1:1.8.5-3.el7
flex.x86_64 0:2.5.37-3.el7 gcc.x86_64 0:4.8.5-11.el7 gcc-c++.x86_64 0:4.8.5-11.el7 gcc-gfortran.x86_64 0:4.8.5-11.el7
git.x86_64 0:1.8.3.1-6.el7_2.1 indent.x86_64 0:2.2.11-13.el7 intltool.noarch 0:0.50.2-6.el7 libtool.x86_64 0:2.4.2-21.el7_2
patch.x86_64 0:2.7.1-8.el7 patchutils.x86_64 0:0.3.3-4.el7 rcs.x86_64 0:5.9.0-5.el7 redhat-rpm-config.noarch 0:9.1.0-72.el7.centos
rpm-build.x86_64 0:4.11.3-21.el7 rpm-sign.x86_64 0:4.11.3-21.el7 subversion.x86_64 0:1.7.14-10.el7 swig.x86_64 0:2.0.10-5.el7
systemtap.x86_64 0:3.0-7.el7

Dependency Installed:
apr.x86_64 0:1.4.8-3.el7 apr-util.x86_64 0:1.5.2-6.el7 avahi-libs.x86_64 0:0.6.31-17.el7
cpp.x86_64 0:4.8.5-11.el7 dwz.x86_64 0:0.11-3.el7 gettext-common-devel.noarch 0:0.18.2.1-4.el7
gettext-devel.x86_64 0:0.18.2.1-4.el7 glibc-devel.x86_64 0:2.17-157.el7_3.1 glibc-headers.x86_64 0:2.17-157.el7_3.1
kernel-devel.x86_64 0:3.10.0-514.10.2.el7 kernel-headers.x86_64 0:3.10.0-514.10.2.el7 libgfortran.x86_64 0:4.8.5-11.el7
libgnome-keyring.x86_64 0:3.8.0-3.el7 libmpc.x86_64 0:1.0.1-3.el7 libquadmath.x86_64 0:4.8.5-11.el7
libquadmath-devel.x86_64 0:4.8.5-11.el7 libstdc++-devel.x86_64 0:4.8.5-11.el7 m4.x86_64 0:1.4.16-10.el7
mokutil.x86_64 0:0.9-2.el7 mpfr.x86_64 0:3.1.1-4.el7 neon.x86_64 0:0.30.0-3.el7
pakchois.x86_64 0:0.4-10.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-Error.noarch 1:0.17020-2.el7
perl-Git.noarch 0:1.8.3.1-6.el7_2.1 perl-TermReadKey.x86_64 0:2.30-20.el7 perl-Test-Harness.noarch 0:3.28-3.el7
perl-Thread-Queue.noarch 0:3.02-2.el7 perl-XML-Parser.x86_64 0:2.41-10.el7 perl-srpm-macros.noarch 0:1-8.el7
subversion-libs.x86_64 0:1.7.14-10.el7 systemtap-client.x86_64 0:3.0-7.el7 systemtap-devel.x86_64 0:3.0-7.el7

Complete!


  • exclude standard yum repos - exclude=postgresql*

vim /etc/yum.repos.d/CentOS-Base.repo

[base]

name=CentOS-$releasever - Base
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os&infra=$infra
#baseurl=http://mirror.centos.org/centos/$releasever/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
exclude=postgresql*

#released updates
[updates]
name=CentOS-$releasever - Updates
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates&infra=$infra
#baseurl=http://mirror.centos.org/centos/$releasever/updates/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
exclude=postgresql*


  • yum local install

yum localinstall https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm

Loaded plugins: fastestmirror, langpacks
pgdg-centos96-9.6-3.noarch.rpm | 4.7 kB 00:00:00
Examining /var/tmp/yum-root-oLVV3g/pgdg-centos96-9.6-3.noarch.rpm: pgdg-centos96-9.6-3.noarch
Marking /var/tmp/yum-root-oLVV3g/pgdg-centos96-9.6-3.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package pgdg-centos96.noarch 0:9.6-3 will be installed
--> Finished Dependency Resolution
base/7/x86_64 | 3.6 kB 00:00:00
extras/7/x86_64 | 3.4 kB 00:00:00
updates/7/x86_64 | 3.4 kB 00:00:00

Dependencies Resolved

=====================================================================================================================================================================
Package Arch Version Repository Size
=====================================================================================================================================================================
Installing:
pgdg-centos96 noarch 9.6-3 /pgdg-centos96-9.6-3.noarch 2.7 k

Transaction Summary
=====================================================================================================================================================================
Install 1 Package

Total size: 2.7 k
Installed size: 2.7 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : pgdg-centos96-9.6-3.noarch 1/1
Verifying : pgdg-centos96-9.6-3.noarch 1/1

Installed:
pgdg-centos96.noarch 0:9.6-3

Complete!


  • yum install

# yum install  postgresql96-server postgresql96-contrib postgresql96-devel

Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* epel: ftp.riken.jp
* epel-debuginfo: ftp.riken.jp
* epel-source: ftp.riken.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
Resolving Dependencies
--> Running transaction check
---> Package postgresql96-contrib.x86_64 0:9.6.2-2PGDG.rhel7 will be installed
--> Processing Dependency: postgresql96-libs(x86-64) = 9.6.2-2PGDG.rhel7 for package: postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64
--> Processing Dependency: postgresql96(x86-64) = 9.6.2-2PGDG.rhel7 for package: postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.22)(64bit) for package: postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.18)(64bit) for package: postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.11)(64bit) for package: postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1()(64bit) for package: postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64
--> Processing Dependency: libpq.so.5()(64bit) for package: postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64
---> Package postgresql96-devel.x86_64 0:9.6.2-2PGDG.rhel7 will be installed
---> Package postgresql96-server.x86_64 0:9.6.2-2PGDG.rhel7 will be installed
--> Running transaction check
---> Package libxslt.x86_64 0:1.1.28-5.el7 will be installed
---> Package postgresql96.x86_64 0:9.6.2-2PGDG.rhel7 will be installed
---> Package postgresql96-libs.x86_64 0:9.6.2-2PGDG.rhel7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================
Package Arch Version Repository Size
=====================================================================================================================================================================
Installing:
postgresql96-contrib x86_64 9.6.2-2PGDG.rhel7 pgdg96 563 k
postgresql96-devel x86_64 9.6.2-2PGDG.rhel7 pgdg96 1.8 M
postgresql96-server x86_64 9.6.2-2PGDG.rhel7 pgdg96 4.3 M
Installing for dependencies:
libxslt x86_64 1.1.28-5.el7 base 242 k
postgresql96 x86_64 9.6.2-2PGDG.rhel7 pgdg96 1.3 M
postgresql96-libs x86_64 9.6.2-2PGDG.rhel7 pgdg96 310 k

Transaction Summary
=====================================================================================================================================================================
Install 3 Packages (+3 Dependent packages)

Total download size: 8.5 M
Installed size: 37 M
Is this ok [y/d/N]: y
Downloading packages:
(1/6): libxslt-1.1.28-5.el7.x86_64.rpm | 242 kB 00:00:00
(2/6): postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64.rpm | 563 kB 00:00:01
(3/6): postgresql96-9.6.2-2PGDG.rhel7.x86_64.rpm | 1.3 MB 00:00:02
(4/6): postgresql96-devel-9.6.2-2PGDG.rhel7.x86_64.rpm | 1.8 MB 00:00:00
(5/6): postgresql96-libs-9.6.2-2PGDG.rhel7.x86_64.rpm | 310 kB 00:00:00
(6/6): postgresql96-server-9.6.2-2PGDG.rhel7.x86_64.rpm | 4.3 MB 00:00:00
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 2.9 MB/s | 8.5 MB 00:00:02
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : postgresql96-libs-9.6.2-2PGDG.rhel7.x86_64 1/6
Installing : postgresql96-9.6.2-2PGDG.rhel7.x86_64 2/6
Installing : libxslt-1.1.28-5.el7.x86_64 3/6
Installing : postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64 4/6
Installing : postgresql96-devel-9.6.2-2PGDG.rhel7.x86_64 5/6
Installing : postgresql96-server-9.6.2-2PGDG.rhel7.x86_64 6/6
Verifying : postgresql96-devel-9.6.2-2PGDG.rhel7.x86_64 1/6
Verifying : libxslt-1.1.28-5.el7.x86_64 2/6
Verifying : postgresql96-9.6.2-2PGDG.rhel7.x86_64 3/6
Verifying : postgresql96-libs-9.6.2-2PGDG.rhel7.x86_64 4/6
Verifying : postgresql96-contrib-9.6.2-2PGDG.rhel7.x86_64 5/6
Verifying : postgresql96-server-9.6.2-2PGDG.rhel7.x86_64 6/6

Installed:
postgresql96-contrib.x86_64 0:9.6.2-2PGDG.rhel7 postgresql96-devel.x86_64 0:9.6.2-2PGDG.rhel7 postgresql96-server.x86_64 0:9.6.2-2PGDG.rhel7

Dependency Installed:
libxslt.x86_64 0:1.1.28-5.el7 postgresql96.x86_64 0:9.6.2-2PGDG.rhel7 postgresql96-libs.x86_64 0:9.6.2-2PGDG.rhel7

Complete!
# yum install openssl-devel
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* epel: ftp.riken.jp
* epel-debuginfo: ftp.riken.jp
* epel-source: ftp.riken.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
Resolving Dependencies
--> Running transaction check
---> Package openssl-devel.x86_64 1:1.0.1e-60.el7_3.1 will be installed
--> Processing Dependency: zlib-devel(x86-64) for package: 1:openssl-devel-1.0.1e-60.el7_3.1.x86_64
--> Processing Dependency: krb5-devel(x86-64) for package: 1:openssl-devel-1.0.1e-60.el7_3.1.x86_64
--> Running transaction check
---> Package krb5-devel.x86_64 0:1.14.1-27.el7_3 will be installed
--> Processing Dependency: libkadm5(x86-64) = 1.14.1-27.el7_3 for package: krb5-devel-1.14.1-27.el7_3.x86_64
--> Processing Dependency: libverto-devel for package: krb5-devel-1.14.1-27.el7_3.x86_64
--> Processing Dependency: libselinux-devel for package: krb5-devel-1.14.1-27.el7_3.x86_64
--> Processing Dependency: libcom_err-devel for package: krb5-devel-1.14.1-27.el7_3.x86_64
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.14.1-27.el7_3.x86_64
---> Package zlib-devel.x86_64 0:1.2.7-17.el7 will be installed
--> Running transaction check
---> Package keyutils-libs-devel.x86_64 0:1.5.8-3.el7 will be installed
---> Package libcom_err-devel.x86_64 0:1.42.9-9.el7 will be installed
---> Package libkadm5.x86_64 0:1.14.1-27.el7_3 will be installed
---> Package libselinux-devel.x86_64 0:2.5-6.el7 will be installed
--> Processing Dependency: libsepol-devel(x86-64) >= 2.5-6 for package: libselinux-devel-2.5-6.el7.x86_64
--> Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.5-6.el7.x86_64
--> Processing Dependency: pkgconfig(libpcre) for package: libselinux-devel-2.5-6.el7.x86_64
---> Package libverto-devel.x86_64 0:0.2.5-4.el7 will be installed
--> Running transaction check
---> Package libsepol-devel.x86_64 0:2.5-6.el7 will be installed
---> Package pcre-devel.x86_64 0:8.32-15.el7_2.1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================
Package Arch Version Repository Size
=====================================================================================================================================================================
Installing:
openssl-devel x86_64 1:1.0.1e-60.el7_3.1 updates 1.2 M
Installing for dependencies:
keyutils-libs-devel x86_64 1.5.8-3.el7 base 37 k
krb5-devel x86_64 1.14.1-27.el7_3 updates 651 k
libcom_err-devel x86_64 1.42.9-9.el7 base 31 k
libkadm5 x86_64 1.14.1-27.el7_3 updates 173 k
libselinux-devel x86_64 2.5-6.el7 base 186 k
libsepol-devel x86_64 2.5-6.el7 base 74 k
libverto-devel x86_64 0.2.5-4.el7 base 12 k
pcre-devel x86_64 8.32-15.el7_2.1 base 479 k
zlib-devel x86_64 1.2.7-17.el7 base 50 k

Transaction Summary
=====================================================================================================================================================================
Install 1 Package (+9 Dependent packages)

Total download size: 2.8 M
Installed size: 5.9 M
Is this ok [y/d/N]: y
Downloading packages:
(1/10): keyutils-libs-devel-1.5.8-3.el7.x86_64.rpm | 37 kB 00:00:00
(2/10): libcom_err-devel-1.42.9-9.el7.x86_64.rpm | 31 kB 00:00:00
(3/10): libselinux-devel-2.5-6.el7.x86_64.rpm | 186 kB 00:00:00
(4/10): krb5-devel-1.14.1-27.el7_3.x86_64.rpm | 651 kB 00:00:00
(5/10): libsepol-devel-2.5-6.el7.x86_64.rpm | 74 kB 00:00:00
(6/10): libkadm5-1.14.1-27.el7_3.x86_64.rpm | 173 kB 00:00:00
(7/10): libverto-devel-0.2.5-4.el7.x86_64.rpm | 12 kB 00:00:00
(8/10): zlib-devel-1.2.7-17.el7.x86_64.rpm | 50 kB 00:00:00
(9/10): openssl-devel-1.0.1e-60.el7_3.1.x86_64.rpm | 1.2 MB 00:00:00
(10/10): pcre-devel-8.32-15.el7_2.1.x86_64.rpm | 479 kB 00:00:00
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 11 MB/s | 2.8 MB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : keyutils-libs-devel-1.5.8-3.el7.x86_64 1/10
Installing : pcre-devel-8.32-15.el7_2.1.x86_64 2/10
Installing : libsepol-devel-2.5-6.el7.x86_64 3/10
Installing : libselinux-devel-2.5-6.el7.x86_64 4/10
Installing : libcom_err-devel-1.42.9-9.el7.x86_64 5/10
Installing : libkadm5-1.14.1-27.el7_3.x86_64 6/10
Installing : libverto-devel-0.2.5-4.el7.x86_64 7/10
Installing : krb5-devel-1.14.1-27.el7_3.x86_64 8/10
Installing : zlib-devel-1.2.7-17.el7.x86_64 9/10
Installing : 1:openssl-devel-1.0.1e-60.el7_3.1.x86_64 10/10
Verifying : zlib-devel-1.2.7-17.el7.x86_64 1/10
Verifying : krb5-devel-1.14.1-27.el7_3.x86_64 2/10
Verifying : libverto-devel-0.2.5-4.el7.x86_64 3/10
Verifying : libkadm5-1.14.1-27.el7_3.x86_64 4/10
Verifying : libcom_err-devel-1.42.9-9.el7.x86_64 5/10
Verifying : libsepol-devel-2.5-6.el7.x86_64 6/10
Verifying : pcre-devel-8.32-15.el7_2.1.x86_64 7/10
Verifying : 1:openssl-devel-1.0.1e-60.el7_3.1.x86_64 8/10
Verifying : libselinux-devel-2.5-6.el7.x86_64 9/10
Verifying : keyutils-libs-devel-1.5.8-3.el7.x86_64 10/10

Installed:
openssl-devel.x86_64 1:1.0.1e-60.el7_3.1

Dependency Installed:
keyutils-libs-devel.x86_64 0:1.5.8-3.el7 krb5-devel.x86_64 0:1.14.1-27.el7_3 libcom_err-devel.x86_64 0:1.42.9-9.el7 libkadm5.x86_64 0:1.14.1-27.el7_3
libselinux-devel.x86_64 0:2.5-6.el7 libsepol-devel.x86_64 0:2.5-6.el7 libverto-devel.x86_64 0:0.2.5-4.el7 pcre-devel.x86_64 0:8.32-15.el7_2.1
zlib-devel.x86_64 0:1.2.7-17.el7

Complete!


  • initialize PostgreSQL

# export PGSETUP_INITDB_OPTIONS="--encoding=UTF-8 --no-locale"

# /usr/pgsql-9.6/bin/postgresql96-setup initdb
Initializing database ... OK

# systemctl enable postgresql-9.6.service
Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-9.6.service to /usr/lib/systemd/system/postgresql-9.6.service.
# systemctl start postgresql-9.6.service
# su - postgres
-bash-4.2$ psql
psql (9.6.2)
Type "help" for help.

postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+---------+-------+-----------------------
postgres | postgres | UTF8 | C | C |
template0 | postgres | UTF8 | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
(3 rows)


  • firewall reload

# firewall-cmd --list-all

public (active)
target: default
icmp-block-inversion: no
interfaces: eth0
sources:
services: dhcpv6-client ssh
ports:
protocols:
masquerade: no
forward-ports:
sourceports:
icmp-blocks:
rich rules:

# firewall-cmd --permanent --add-service=postgresql
success

# firewall-cmd --list-all
public (active)
target: default
icmp-block-inversion: no
interfaces: eth0
sources:
services: dhcpv6-client ssh
ports:
protocols:
masquerade: no
forward-ports:
sourceports:
icmp-blocks:
rich rules:

# firewall-cmd --reload
success

# firewall-cmd --list-all
public (active)
target: default
icmp-block-inversion: no
interfaces: eth0
sources:
services: dhcpv6-client postgresql ssh
ports:
protocols:
masquerade: no
forward-ports:
sourceports:
icmp-blocks:
rich rules:


  • additional

# diff postgresql.conf postgresql.conf-

59d58
< listen_addresses = '*' # what IP address(es) to listen on;
64c63
< port = 5432 # (change requires restart)
---
> #port = 5432 # (change requires restart)
114,115c113
< shared_buffers = 1024MB # min 128kB
< #shared_buffers = 128MB # min 128kB
---
> shared_buffers = 128MB # min 128kB
119d116
< temp_buffers = 8MB # min 800kB
125d121
< work_mem = 4MB # min 64kB
148d143
< shared_preload_libraries = 'plugin_debugger' # (change requires restart)
191d185
< wal_buffers = 16MB # min 32kB, -1 sets based on shared_buffers
201d194
< checkpoint_segments = 16 # in logfile segments, min 1, 16MB each

# diff pg_hba.conf pg_hba.conf-
82,83c82
< #host all all 127.0.0.1/32 ident
< host all all all password
---
> host all all 127.0.0.1/32 ident

:blossom: