麒麟KylinV10编译安装Postgres17.4

## 安装编译环境及依赖

```bash
yum install -y openssl openssl-devel pam pam-devel \
perl-devel python-devel perl-ExtUtils-Embed readline \
readline-devel  zlib zlib-devel gettext gettext-devel \
bison flex  gcc gcc-c++ uuid uuid-devel openldap-devel \
systemd-devel libxml2 libxml2-devel libxslt libxslt-devel \
perl libicu-devel cmake
```

## 新建用户及目标目录
```
useradd postgres  						# 不允许在特权帐号下允许
echo 'admin'|passwd --stdin postgres 	 # 用户密码为admin
mkdir /data/postgres/{logs,systemd}
```

## 编译安装postgresQL

```bash
tar -zxvf postgresql-17.4.tar.gz
cd postgresql-17.4/
./configure --prefix=/data/postgres --with-libxml \
--with-libxslt --with-perl --with-pgport=5432 --with-openssl \
--with-ossp-uuid --with-systemd --with-blocksize=16
make -j $(nproc) && make install
chown postgres.postgres -R /data/postgres
```
参数说明

- --with-blocksize=16  #根据业务需求选择编译的内容,默认8
- --with-system #可注册成系统服务。

## 初始化数据库

```
sudo -u postgres /data/postgres/bin/initdb -D \
/data/postgres/datadir -E UTF8 --locale=zh_CN.utf8
```

![](/media/202503/2025-03-28_143630_6120530.9652482745387674.png)

## 基础配置

配置远程访问
```
cat /data/postgres/datadir/postgresql.conf
host    all             all             0.0.0.0/0               trust
```

配置端口
```
cat /data/postgres/datadir/postgresql.conf
listen_addresses = '0.0.0.0'
prot = 5432
max_connections = 9999
```

## 注册服务

```
cat /etc/systemd/system/postgres.service
```
```
[Unit]
Description=PostgreSQL database server
After=network.target

[Service]
Type=forking
User=postgres
ExecStart=/data/postgres/bin/pg_ctl start -D /data/postgres/datadir -l /data/postgres/logs/postgres.log
ExecStop=/data/postgres/bin/pg_ctl stop -D /data/postgres/data

[Install]
WantedBy=multi-user.target
```

## 环境变量设置

使用postgres用户，环境变量使用/home/postgres/.bashrc文件

```bash
cat /home/postgres/.bashrc
```
```
export PGHOME=/data/postgres
export PGDATA=/data/postgres/datadir
export LD_LIBRARY_PATH=$PGHOME/lib:lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/lib:$LD_LIBRARY_PATH
export DATE='date +"%Y%m%d%H%M"'
export PATH=$PGHOME/bin:$PATH:.
export MANPATH=$PGHOME/share/man:$MANPATH
```

## 启动Postgres服务

```
systemctl daemon-reload
systemctl enable postgres.service
systemctl start postgres
```

## 设置管理密码

```
sudo -u postgres /data/postgres/bin/psql
alter user postgres with password 'postgres';
exit;
```
## 开放端口

查询指定端口是否已开
```
firewall-cmd --query-port=5432/tcp
```
提示 yes，表示开启；no表示未开启。

添加需要开放的端口
```
firewall-cmd --add-port=5432/tcp --permanent
firewall-cmd --reload
```