记录一次PostgreSQL库13.3版本升级到13.19版本

**

记录一次PostgreSQL库13.3版本升级到13.19版本

**

1 停止数据库
systemctl stop postgresql-13
2 查看安装了哪些数据库rpm包
rpm -qa | grep postgres
3 卸载旧rpm包
rpm -e postgresql13-server-13.3-1PGDG.rhel7.x86_64
rpm -e postgresql13-13.3-1PGDG.rhel7.x86_64
rpm -e postgresql13-libs-13.3-1PGDG.rhel7.x86_64
4 再次查看是否成功卸载数据库rpm包
rpm -qa | grep postgres
5 安装新rpm包
rpm -ivh postgresql13-libs-13.19-1PGDG.rhel7.x86_64.rpm
rpm -ivh postgresql13-13.19-1PGDG.rhel7.x86_64.rpm
rpm -ivh postgresql13-server-13.19-1PGDG.rhel7.x86_64.rpm
6 查看是否成功安装新rpm包
rpm -qa | grep postgres
7 修改启动文件
vim /usr/lib/systemd/system/postgresql-13.service
Environment=PGDATA=/appdata/pgdata
8 重新启动数据库
systemctl daemon-reload
systemctl start postgresql-13
9 开启自启动
systemctl disable postgresql-13
systemctl enable postgresql-13
10 查看数据库进程
ps -ef | grep postgres