1. 安装编译依赖

sudo dnf install -y gcc make openssl-devel readline-devel zlib-devel

2. 下载 PostgreSQL 15 源码

cd /tmp
wget https://ftp.postgresql.org/pub/source/v15.15/postgresql-15.15.tar.gz
tar -xzf postgresql-15.15.tar.gz
cd postgresql-15.15

3. 编译客户端（仅客户端）

./configure --prefix=/usr/local/postgresql15 --enable-static --disable-shared --without-server
make
make install

4. 添加到 PATH

echo 'export PATH=/usr/local/postgresql15/bin:$PATH' >> ~/.bashrc
source ~/.bashrc

5. 验证

psql --version

[root@localhost~]# psql   --version
psql (PostgreSQL) 15.15