Openeuler 24.03 源码安装 Postgresql17.5

安装所需依赖

dnf install tar readline-devel zlib-devel -y

下载pg安装包

wget wget https://ftp.postgresql.org/pub/source/v17.5/postgresql-17.5.tar.gz

tar -xvf postgresql-17.5.tar.gz
cd postgresql-17.5
./configure
make -j$(nproc)
make install

创建pg用户并初始化数据库以及启动数据库

adduser postgres
mkdir -p /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

修改数据库密码

/usr/local/pgsql/bin/psql
alter user postgres with password 'postgres';

允许远程访问

修改 /usr/local/pgsql/data/pg_hba.conf
在 # IPv4 local connections: 这一行下增加
host all all 0.0.0.0/0 md5

修改 /home/application/gis/pgsql/data/postgresql.conf

修改成如下示例

listen_addresses = '*'

制作成服务

cp ./contrib/start-scripts/linux /etc/init.d/postgresql
chmod +x /etc/init.d/postgresql
systemctl daemon-reload
chkconfig --add postgresql
systemctl restart postgresql
systemctl status postgresql