centos7 install postgres-15
env centos7
1.更新包，避免安装时出错
yum update2. PostgreSQL: Linux downloads (Red Hat family)
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 postgresql15-server
sudo /usr/pgsql-15/bin/postgresql-15-setup initdb
sudo systemctl enable postgresql-15
sudo systemctl start postgresql-153. 安装遇到libzstd >= 1.4.0 问题
wget https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/l/libzstd-1.5.5-1.el7.x86_64.rpm
wget https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/l/llvm5.0-devel-5.0.1-7.el7.x86_64.rpm
wget https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/l/llvm5.0-5.0.1-7.el7.x86_64.rpm
wget https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/l/llvm5.0-libs-5.0.1-7.el7.x86_64.rpmyum install -y ./libzstd-1.5.5-1.el7.x86_64.rpm
yum install -y centos-release-scl-rh llvm5*4.重新安装：
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 postgresql15-server
sudo /usr/pgsql-15/bin/postgresql-15-setup initdb
sudo systemctl enable postgresql-15
sudo systemctl start postgresql-155.修改监听端口
/var/lib/pgsql/15/data/postgresql.conf
#listen_addresses = 'localhost' # what IP address(es) to listen on;
listen_addresses = '0.0.0.0' # what IP address(es) to listen on;
简单监听所有ip
默认仅监听localhost
6.修改访问权限
/var/lib/pgsql/15/data/pg_hba.conf
新增：
host all all 192.168.1.0/24 password
# METHOD can be "trust", "reject", "md5", "password", "scram-sha-256",
# "gss", "sspi", "ident", "peer", "pam", "ldap", "radius" or "cert".
# Note that "password" sends passwords in clear text; "md5" or
# "scram-sha-256" are preferred since they send encrypted passwords.# Allow replication connections from localhost, by a user with the
# 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
host all all 192.168.1.0/24 password
pg_hba.conf解决问题：
Connect failed: no pg_hba.conf entry for host
7.开放防火墙
firewall-cmd --zone=public --add-port=5432/tcp --permanent
配置生效
firewall-cmd --reload # 配置立即生效参考：命令
开放TCP端口 firewall-cmd --zone=public --add-port=80/tcp --permanent # 开放tcp80端口 firewall-cmd --zone=public --add-port=443/tcp --permanent # 开放tcp443端口 firewall-cmd --zone=public --add-port=3306/tcp --permanent # 开放tcp3306端口 firewall-cmd --zone=public --add-port=6379/tcp --permanent # 开放tcp6379端口开放UDP端口 firewall-cmd --zone=public --add-port=9595/udp --permanent # 开放udp9595端口关闭TCP端口 firewall-cmd --zone=public --remove-port=80/tcp --permanent #关闭tcp5672端口 firewall-cmd --zone=public --remove-port=443/tcp --permanent #关闭tcp443端口 firewall-cmd --zone=public --remove-port=3306/tcp --permanent #关闭tcp3306端口 firewall-cmd --zone=public --remove-port=6379/tcp --permanent #关闭tcp6379端口关闭UDP端口 firewall-cmd --zone=public --remove-port=9595/udp--permanent #关闭udp9595端口配置生效 firewall-cmd --reload # 配置立即生效查看防火墙所有开放的端口 firewall-cmd --zone=public --list-ports关闭防火墙 如果要开放的端口太多，嫌麻烦，可以关闭防火墙 systemctl stop firewalld.service查看防火墙状态 firewall-cmd --state查看监听的端口 TCP：netstat -ntlp UDP: netstat -nulp
8.修改postgres密码
# sudo -u postgres psqlpsql (15.4)
Type "help" for help.postgres=# ALTER USER postgres WITH PASSWORD 'xxxxxxxxxxx';
ALTER ROLE
使用修改后的密码登录测试ok
参考：
PostgreSQL 连接问题 FATAL: no pg_hba.conf entry for host_org.postgresql.util.psqlexception: fatal: no pg_hb-CSDN博客
PostgreSQL: Linux downloads (Red Hat family)
centos7.9安装postgresql15报错_vah101的博客-CSDN博客
PostgreSQL 配置文件 postgresql.conf 及 postgresql.auto.conf-CSDN博客
Centos7开放端口及查看端口开放-腾讯云开发者社区-腾讯云 (tencent.com)
如何查看PostgreSQL 的配置文件在哪里 - 简书 (jianshu.com)
PostgreSQL数据库默认用户postgres的密码 - 郑道杰 - 博客园 (cnblogs.com)