centos7离线安装postgresql13

ζั͡山 ั͡有扶苏 ั͡✾

于 2024-04-16 18:28:16 发布

阅读量687

点赞数 13

分类专栏： Linux运维文章标签： postgresql linux

本文链接：https://blog.csdn.net/qq_43479188/article/details/137835123

版权

Linux运维专栏收录该内容

45 篇文章 1 订阅

订阅专栏

一.安装存储库RPM

yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

二.使用yumdownloader下载安装包

mkdir pg_yum
cd pg_yum
yumdownloader --resolve postgresql13-server

三.上传rpm包到安装的centos服务器上

scp -r pg_yum/ <目标服务器IP>:/home/

在这里插入图片描述

三.批量安装rpm包

rpm -ivh postgresql13-13.14-1PGDG.rhel7.x86_64.rpm postgresql13-libs-13.14-1PGDG.rhel7.x86_64.rpm postgresql13-server-13.14-1PGDG.rhel7.x86_64.rpm

1.如果报错，缺少依赖libicu

warning: postgresql13-13.4-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
error: Failed dependencies:
        libicu is needed by postgresql13-13.4-1PGDG.rhel7.x86_64
        libicui18n.so.50()(64bit) is needed by postgresql13-server-13.4-1PGDG.rhel7.x86_64
        libicuuc.so.50()(64bit) is needed by postgresql13-server-13.4-1PGDG.rhel7.x86_64

3.使用yumdownloader下载libicu

mkdir libicu
cd libicu
yumdownloader --resolve libicu

在这里插入图片描述
删除libicu-50.2-4.el7_7.i686.rpm。

4.上传到需要安装的服务器，执行安装命令

scp -r pg_yum/ <目标服务器IP>:/home/
cd libicu
rpm -ivh libicu-50.2-4.el7_7.x86_64.rpm

然后再安装pgsql

cd ../pg_yum/
rpm -ivh postgresql13-13.14-1PGDG.rhel7.x86_64.rpm postgresql13-libs-13.14-1PGDG.rhel7.x86_64.rpm postgresql13-server-13.14-1PGDG.rhel7.x86_64.rpm

四.安装成功后初始化数据库

/usr/pgsql-13/bin/postgresql-13-setup initdb

五.启动postgresql数据库

systemctl enable postgresql-13
systemctl start postgresql-13

六.配置postgres用户密码，开放端口

su - postgres
psql
ALTER USER postgres WITH PASSWORD 'new_password';
#退出
\q
#防火墙开放端口
firewall-cmd --add-port=5432/tcp --permanent
firewall-cmd --reload