我这里把全套所需的程序安装包都整理好了,混个资源分,如果实在没积分的兄弟,继续往下,按我写的步骤自己下也行。
PG14 离线程序安装包及依赖包全套下载
1. 下载离线安装包
下载链接 PostgreSQL PGDG 14 Updates RPMs
依次进入下载
2. 下载依赖包
安装时报错,缺少 libicu
依赖
[root@server149058 postgresql]# rpm -ivh postgresql14-14.5-1PGDG.rhel7.x86_64.rpm
warning: postgresql14-14.5-1PGDG.rhel7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
error: Failed dependencies:
libicu is needed by postgresql14-14.5-1PGDG.rhel7.x86_64
下载链接 RPM resource libicu
3. 安装程序包
按顺序安装
rpm -ivh libicu-50.2-4.el7_7.x86_64.rpm
rpm -ivh postgresql14-libs-14.5-1PGDG.rhel7.x86_64.rpm
rpm -ivh postgresql14-14.5-1PGDG.rhel7.x86_64.rpm
rpm -ivh postgresql14-server-14.5-1PGDG.rhel7.x86_64.rpm
4. 安装后操作
4.1 初始化数据库
[root@server149058 postgresql]# /usr/pgsql-14/bin/postgresql-14-setup initdb
Initializing database ... OK
4.2 修改配置文件
[root@server149058 postgresql]# vi /var/lib/pgsql/14/data/postgresql.conf
listen_addresses = '*' # 允许外部连接
port = 5432 # 端口号
4.3 开放允许访问 ip
[root@server149058 data]# vi /var/lib/pgsql/14/data/pg_hba.conf
# replication privilege.
local replication all peer
host replication all 127.0.0.1/32 scram-sha-256
host replication all ::1/128 scram-sha-256
# 添加下面这行,允许所有 ip 访问
host all all 0.0.0.0/0 md5
放行防火墙端口
[root@server149058 data]# firewall-cmd --permanent --add-port 5432/tcp
[root@server149058 data]# firewall-cmd --reload
4.4 重启服务
[root@server149058 ~]# systemctl reload postgresql-14
[root@server149058 ~]# systemctl restart postgresql-14
4.5 配置用户
创建 testuser
用户
[root@server149058 ~]# su postgres
bash-4.2$ psql
could not change directory to "/root": Permission denied
psql (14.5)
Type "help" for help.
postgres=# create user testuser password 'TestMyPass';
CREATE ROLE
赋予超管权限
postgres=# ALTER ROLE testuser SUPERUSER;
ALTER ROLE
4.6 客户端登录
连接成功。