Linux操作系统Centos7 安装postgre15及报错问题解决错误：软件包：postgresql15-15.7-1PGDG.rhel7.x86_64 (pgdg15)

进入官网PostgreSQL: Linux downloads (Red Hat family)

选择对应安装版本

执行下面命令

# Install the repository RPM: sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Install PostgreSQL:
sudo yum install -y postgresql15-server

如果报如下错误：

centos7 安装postgre15的时候报错如下
错误：软件包：postgresql15-15.7-1PGDG.rhel7.x86_64 (pgdg15)
          需要：libzstd >= 1.4.0
错误：软件包：postgresql15-15.7-1PGDG.rhel7.x86_64 (pgdg15)
          需要：libzstd.so.1()(64bit)
错误：软件包：postgresql15-server-15.7-1PGDG.rhel7.x86_64 (pgdg15)
          需要：libzstd.so.1()(64bit)

解决方案：依次执行下面五条命令

 wget https://archives.fedoraproject.org/pub/archive/epel/7/x86_64/Packages/l/libzstd-1.5.5-1.el7.x86_64.rpm
wget https://archives.fedoraproject.org/pub/archive/epel/7/x86_64/Packages/l/llvm9.0-9.0.1-9.el7.x86_64.rpm
wget https://archives.fedoraproject.org/pub/archive/epel/7/x86_64/Packages/l/llvm9.0-devel-9.0.1-9.el7.x86_64.rpm
wget https://archives.fedoraproject.org/pub/archive/epel/7/x86_64/Packages/l/llvm9.0-libs-9.0.1-9.el7.x86_64.rpm
 
yum install -y ./libzstd-1.5.5-1.el7.x86_64.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-15

成功解决！