postgresql 数据库小版本更新
记录一次pg小版本更新
文章目录
前言
因为最近漏扫发现好多漏洞,需要升级pg数据库的版本用以解决漏洞问题,有些数据库不能升级大版本,只能升级小版本,网上全是讲的编译安装的,我在这里说说rpm安装如何升级。
一.下载最新的pg版本 pg11(11.18)
官网直接下载
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
安装
sudo yum install -y postgresql11-server
- 自己下载安装包及依赖
需要下载4个对应版本的rpm包。
下载地址:
https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/
已下载好的文件地址:pg11.18的资源
https://download.csdn.net/download/yang_z_1/87432521
把下载包放到一个目录下,上传到所需的Linux服务器
在文件目录下执行
yum localinstall *.rpm -y
[root@hrmw-template pg11.18]# yum localinstall *.rpm -y
Loaded plugins: fastestmirror
Examining postgresql11-11.18-1PGDG.rhel7.x86_64.rpm: postgresql11-11.18-1PGDG.rhel7.x86_64
Marking postgresql11-11.18-1PGDG.rhel7.x86_64.rpm as an update to postgresql11-11.5-1PGDG.rhel7.x86_64
Examining postgresql11-contrib-11.18-1PGDG.rhel7.x86_64.rpm: postgresql11-contrib-11.18-1PGDG.rhel7.x86_64
Marking postgresql11-contrib-11.18-1PGDG.rhel7.x86_64.rpm as an update to postgresql11-contrib-11.5-1PGDG.rhel7.x86_64
Examining postgresql11-libs-11.18-1PGDG.rhel7.x86_64.rpm: postgresql11-libs-11.18-1PGDG.rhel7.x86_64
Marking postgresql11-libs-11.18-1PGDG.rhel7.x86_64.rpm as an update to postgresql11-libs-11.5-1PGDG.rhel7.x86_64
Examining postgresql11-server-11.18-1PGDG.rhel7.x86_64.rpm: postgresql11-server-11.18-1PGDG.rhel7.x86_64
Marking postgresql11-server-11.18-1PGDG.rhel7.x86_64.rpm as an update to postgresql11-server-11.5-1PGDG.rhel7.x86_64
Resolving Dependencies
--> Running transaction check
---> Package postgresql11.x86_64 0:11.5-1PGDG.rhel7 will be updated
---> Package postgresql11.x86_64 0:11.18-1PGDG.rhel7 will be an update
---> Package postgresql11-contrib.x86_64 0:11.5-1PGDG.rhel7 will be updated
---> Package postgresql11-contrib.x86_64 0:11.18-1PGDG.rhel7 will be an update
---> Package postgresql11-libs.x86_64 0:11.5-1PGDG.rhel7 will be updated
---> Package postgresql11-libs.x86_64 0:11.18-1PGDG.rhel7 will be an update
---> Package postgresql11-server.x86_64 0