RockyLinux8 & RockyLinux9安装postgresql16-devel开发包

1、PG的插件扩展有些需要自行编译，需要安装PG开发包

2、RockyLinux8安装

#创建用户先
useradd postgres
 
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf install -y postgresql16-server
#安装开发包依赖
sudo dnf install epel-release -y 
sudo dnf --enablerepo=powertools install perl-IPC-Run -y
 
dnf install -y cmake make gcc zlib gcc-c++ perl readline readline-devel zlib zlib-devel perl python36 tcl openssl ncurses-devel openldap pam perl-IPC-Run libicu-devel
 
#安装扩展
sudo dnf install -y postgresql16-contrib
#安装开发包
sudo dnf install -y postgresql16-devel
 
sudo /usr/pgsql-16/bin/postgresql-16-setup initdb
sudo systemctl enable postgresql-16
sudo systemctl start postgresql-16

3、RockyLinux9安装

#创建用户先
useradd postgres
 
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf install -y postgresql16-server
#安装开发包依赖 
sudo dnf install epel-release -y 
#Powertools is known as crb under RL9. dnf config-manager --enable crb
sudo dnf config-manager --set-enabled crb
 
dnf install -y cmake make gcc zlib gcc-c++ perl readline readline-devel zlib zlib-devel perl python36 tcl openssl ncurses-devel openldap pam perl-IPC-Run libicu-devel
 
#安装扩展
sudo dnf install -y postgresql16-contrib
#安装开发包
sudo dnf install -y postgresql16-devel
 
sudo /usr/pgsql-16/bin/postgresql-16-setup initdb
sudo systemctl enable postgresql-16
sudo systemctl start postgresql-16