RockyLinux8 & RockyLinux9安装postgresql16-devel开发包

最新推荐文章于 2025-10-23 15:31:04 发布

原创最新推荐文章于 2025-10-23 15:31:04 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#postgresql

本文详细描述了如何在RockyLinux8和9系统中安装PostgreSQL16服务器，包括创建用户、添加pgdg仓库、安装必要的开发包、启用扩展和开发环境，以及设置服务初始化和启动。

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