1. 创建系统用户

sudo useradd -m -s /bin/bash postgres
sudo passwd postgres

2.创建数据目录

sudo mkdir -p /usr/local/pgsql/data
sudo chown postgres:postgres /usr/local/pgsql/data

3.安装依赖

sudo dnf install -y readline-devel zlib-devel bison flex libxml2-devel libxslt-devel openssl-devel wget gcc gcc-c++ make

4.下载 PostgreSQL 17 源码包

wget https://ftp.postgresql.org/pub/source/v17.6/postgresql-17.6.tar.gz

5.解压 PostgreSQL 17 源码包

tar -zxvf postgresql-17.6.tar.gz

6.编译并安装

cd postgresql-17.6
./configure  --prefix=/usr/local/pgsql 

7.安装 contrib 模块

cd postgresql-17.6/contrib
sudo make -j$(nproc)
sudo make install

8.初始化数据库

su - postgres
export PATH=/usr/local/pgsql/bin:$PATH
initdb -D /usr/local/pgsql/data

9.启动 PostgreSQL

pg_ctl -D /usr/local/pgsql/data -l /usr/local/pgsql/data/logfile start

10.验证

psql -U postgres -h localhost -p 5432