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进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
文章被以下合辑收录
评论
冷狼
4月前
评论
0postgresql12-Linux中 RPM 安装
4月前
点赞 评论
相关阅读
王炸！OGG 23ai 终于支持从PostgreSQL备库抽取数据了
曹海峰
408次阅读
2025-03-09 12:54:06
玩一玩系列——玩玩login_hook（一款即将停止维护的PostgreSQL登录插件）
小满未满、
375次阅读
2025-03-08 18:19:28
明明想执行的SQL是DELETE、UPDATE，但为什么看到的是SELECT（FDW的实现原理解析）
小满未满、
354次阅读
2025-03-19 23:11:26
PostgreSQL初/中/高级认证考试（3.15）通过考生公示
开源软件联盟PostgreSQL分会
309次阅读
2025-03-20 09:50:36
IvorySQL 4.4 发布 - 基于 PostgreSQL 17.4，增强平台支持
通讯员
198次阅读
2025-03-20 15:31:04
套壳论
梧桐
196次阅读
2025-03-09 10:58:17
命名不规范，事后泪两行
xiongcc
184次阅读
2025-03-13 14:26:08
快速搭建知识库deepseek+ragflow离线环境安装部署实战篇
墨竹
170次阅读
2025-03-06 15:47:49
PG vs MySQL 执行计划解读的异同点
进击的CJR
124次阅读
2025-03-21 10:50:08
版本发布｜ IvorySQL 4.4 发布
IvorySQL开源数据库社区
115次阅读
2025-03-13 09:52:33
