1、软件包准备
需要在官网下载以下四个软件包：
- postgresql12-libs-12.3-1PGDG.rhel6.x86_64.rpm
- postgresql12-12.3-1PGDG.rhel6.x86_64
- postgresql12-server-12.3-1PGDG.rhel6.x86_64.rpm
- postgresql12-contrib-12.3-1PGDG.rhel6.x86_64.rpm
2、postgre安装
本次实验使用的环境是 Red Hat Enterprise Linux Server release 6.4
# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.4 (Santiago)
rpm包安装比较简单，需要按照以下顺序进行安装
rpm -ivh postgresql12-libs-12.3-1PGDG.rhel6.x86_64.rpm
rpm -ivh postgresql12-12.3-1PGDG.rhel6.x86_64.rpm
rpm -ivh postgresql12-server-12.3-1PGDG.rhel6.x86_64.rpm
rpm -ivh postgresql12-contrib-12.3-1PGDG.rhel6.x86_64.rpm
可能会缺以下依赖包，yum安装一下
yum -y install libicu
yum -y install libxslt
在安装的时候可能会出现openssl相关报错
# rpm -ivh postgresql12-libs-12.3-1PGDG.rhel6.x86_64.rpm
warning: postgresql12-libs-12.3-1PGDG.rhel6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
error: Failed dependencies:
libcrypto.so.10(libcrypto.so.10)(64bit) is needed by postgresql12-libs-12.3-1PGDG.rhel6.x86_64
libssl.so.10(libssl.so.10)(64bit) is needed by postgresql12-libs-12.3-1PGDG.rhel6.x86_64
[root@mysql ~]# ldconfig -p | grep libcrypto.so
libcrypto.so.10 (libc6,x86-64) => /usr/lib64/libcrypto.so.10
查看openssl包提供的功能
# rpm -q --provides openssl
config(openssl) = 1.0.0-27.el6
lib4758cca.so()(64bit)
libaep.so()(64bit)
libatalla.so()(64bit)
libcapi.so()(64bit)
libchil.so()(64bit)
libcrypto.so.10()(64bit)
libcswift.so()(64bit)
libgmp.so()(64bit)
libnuron.so()(64bit)
libpadlock.so()(64bit)
libssl.so.10()(64bit)
libsureware.so()(64bit)
libubsec.so()(64bit)
openssl = 1.0.0-27.el6
openssl(x86-64) = 1.0.0-27.el6
重新安装openssl后正常，可以正常执行postgre包的安装
# rpm -qa|grep openssl
openssl-1.0.0-27.el6.x86_64
# rpm -e openssl-1.0.0-27.el6.x86_64
error: Failed dependencies:
libcrypto.so.10()(64bit) is needed by (installed) gnome-vfs2-2.24.2-6.el6.x86_64
libcrypto.so.10()(64bit) is needed by (installed) libssh2-1.4.2-1.el6.x86_64
libcrypto.so.10()(64bit) is needed by (installed) mysql-libs-5.1.66-2.el6_3.x86_64
libcrypto.so.10()(64bit) is needed by (installed) fipscheck-1.2.0-7.el6.x86_64
libcrypto.so.10()(64bit) is needed by (installed) python-2.6.6-36.el6.x86_64
libcrypto.so.10()(64bit) is needed by (installed) m2crypto-0.20.2-9.el6.x86_64
libcrypto.so.10()(64bit) is needed by (installed) pyOpenSSL-0.10-2.el6.x86_64
libcrypto.so.10()(64bit) is needed by (installed) openssh-5.3p1-84.1.el6.x86_64
libcrypto.so.10()(64bit) is needed by (installed) cyrus-sasl-2.1.23-13.el6_3.1.x86_64
libcrypto.so.10()(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
libcrypto.so.10()(64bit) is needed by (installed) openssh-server-5.3p1-84.1.el6.x86_64
libcrypto.so.10()(64bit) is needed by (installed) wget-1.12-1.8.el6.x86_64
libssl.so.10()(64bit) is needed by (installed) gnome-vfs2-2.24.2-6.el6.x86_64
libssl.so.10()(64bit) is needed by (installed) libssh2-1.4.2-1.el6.x86_64
libssl.so.10()(64bit) is needed by (installed) mysql-libs-5.1.66-2.el6_3.x86_64
libssl.so.10()(64bit) is needed by (installed) python-2.6.6-36.el6.x86_64
libssl.so.10()(64bit) is needed by (installed) m2crypto-0.20.2-9.el6.x86_64
libssl.so.10()(64bit) is needed by (installed) python-rhsm-1.1.8-1.el6.x86_64
libssl.so.10()(64bit) is needed by (installed) pyOpenSSL-0.10-2.el6.x86_64
libssl.so.10()(64bit) is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
libssl.so.10()(64bit) is needed by (installed) wget-1.12-1.8.el6.x86_64
openssl is needed by (installed) postfix-2:2.6.6-2.2.el6_1.x86_64
# rpm -e openssl-1.0.0-27.el6.x86_64 --nodeps
# rpm -ivh openssl-1.0.1e-57.el6.x86_64.rpm
warning: openssl-1.0.1e-57.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY
Preparing... ########################################### [100%]
1:openssl ########################################### [100%]
# openssl version
OpenSSL 1.0.1e-fips 11 Feb 2013
# ldconfig -v|grep libcrypto
libcrypto.so.10 -> libcrypto.so.1.0.1e
# rpm -q --provides openssl
config(openssl) = 1.0.1e-57.el6
lib4758cca.so()(64bit)
lib4758cca.so(OPENSSL_1.0.1)(64bit)
lib4758cca.so(OPENSSL_1.0.1_EC)(64bit)
lib4758cca.so(lib4758cca.so)(64bit)
libaep.so()(64bit)
libaep.so(OPENSSL_1.0.1)(64bit)
libaep.so(OPENSSL_1.0.1_EC)(64bit)
libaep.so(libaep.so)(64bit)
libatalla.so()(64bit)
libatalla.so(OPENSSL_1.0.1)(64bit)
libatalla.so(OPENSSL_1.0.1_EC)(64bit)
libatalla.so(libatalla.so)(64bit)
libcapi.so()(64bit)
libcapi.so(OPENSSL_1.0.1)(64bit)
libcapi.so(OPENSSL_1.0.1_EC)(64bit)
libcapi.so(libcapi.so)(64bit)
libchil.so()(64bit)
libchil.so(OPENSSL_1.0.1)(64bit)
libchil.so(OPENSSL_1.0.1_EC)(64bit)
libchil.so(libchil.so)(64bit)
libcrypto.so.10()(64bit)
libcrypto.so.10(OPENSSL_1.0.1)(64bit)
libcrypto.so.10(OPENSSL_1.0.1_EC)(64bit)
libcrypto.so.10(libcrypto.so.10)(64bit)
libcswift.so()(64bit)
libcswift.so(OPENSSL_1.0.1)(64bit)
libcswift.so(OPENSSL_1.0.1_EC)(64bit)
libcswift.so(libcswift.so)(64bit)
libgmp.so()(64bit)
libgmp.so(OPENSSL_1.0.1)(64bit)
libgmp.so(OPENSSL_1.0.1_EC)(64bit)
libgmp.so(libgmp.so)(64bit)
libnuron.so()(64bit)
libnuron.so(OPENSSL_1.0.1)(64bit)
libnuron.so(OPENSSL_1.0.1_EC)(64bit)
libnuron.so(libnuron.so)(64bit)
libpadlock.so()(64bit)
libpadlock.so(OPENSSL_1.0.1)(64bit)
libpadlock.so(OPENSSL_1.0.1_EC)(64bit)
libpadlock.so(libpadlock.so)(64bit)
libssl.so.10()(64bit)
libssl.so.10(OPENSSL_1.0.1)(64bit)
libssl.so.10(OPENSSL_1.0.1_EC)(64bit)
libssl.so.10(libssl.so.10)(64bit)
libsureware.so()(64bit)
libsureware.so(OPENSSL_1.0.1)(64bit)
libsureware.so(OPENSSL_1.0.1_EC)(64bit)
libsureware.so(libsureware.so)(64bit)
libubsec.so()(64bit)
libubsec.so(OPENSSL_1.0.1)(64bit)
libubsec.so(OPENSSL_1.0.1_EC)(64bit)
libubsec.so(libubsec.so)(64bit)
openssl = 1.0.1e-57.el6
openssl(x86-64) = 1.0.1e-57.el6
3、初始化数据库
# service postgresql-12 initdb
Initializing database: [ OK ]
4、启动数据库服务
# service postgresql-12 start
Starting postgresql-12 service: [ OK ]
正常启动后，可以看到postgre相关进程已经起来了，postgre相关配置文件和数据文件在 /var/lib/pgsql/12/data 目录下
# ps -ef|grep post
postgres 16706 1 0 01:42 ? 00:00:00 /usr/pgsql-12/bin/postmaster -D /var/lib/pgsql/12/data
postgres 16708 16706 0 01:42 ? 00:00:00 postgres: logger
postgres 16710 16706 0 01:42 ? 00:00:00 postgres: checkpointer
postgres 16711 16706 0 01:42 ? 00:00:00 postgres: background writer
postgres 16712 16706 0 01:42 ? 00:00:00 postgres: walwriter
postgres 16713 16706 0 01:42 ? 00:00:00 postgres: autovacuum launcher
postgres 16714 16706 0 01:42 ? 00:00:00 postgres: stats collector
postgres 16715 16706 0 01:42 ? 00:00:00 postgres: logical replication launcher
远程监听端口默认为5432
# netstat -apln|grep 16706
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 16706/postmaster
tcp 0 0 ::1:5432 :::* LISTEN 16706/postmaster
udp 0 0 ::1:50285 ::1:50285 ESTABLISHED 16706/postmaster
unix 2 [ ACC ] STREAM LISTENING 46492 16706/postmaster /tmp/.s.PGSQL.5432
unix 2 [ ACC ] STREAM LISTENING 46489 16706/postmaster /var/run/postgresql/.s.PGSQL.5432
5、测试数据库
# su - postgres
-bash-4.1$ psql
psql (12.3)
Type "help" for help.
postgres=# \t
Tuples only is on.
postgres=# \l
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
最后修改时间：2020-07-30 13:58:38
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
