yum install -y gcc make readline-devel zlib-devel libicu-devel

cd /usr/local

tar zxvf postgresql-16.0.tar.gz

cd postgresql-16.0

./configure --prefix=/usr/local/postgresql

make -j8 && make install

adduser pgsql

mkdir /usr/local/postgresql/data

chown pgsql /usr/local/postgresql/data

su - pgsql

##初始化数据库
/usr/local/postgresql/bin/initdb -D /usr/local/postgresql/data

##启动数据库
/usr/local/postgresql/bin/pg_ctl -D /usr/local/postgresql/data -l logfile start

/usr/local/postgresql/bin/psql -d postgres

CREATE USER postgres WITH PASSWORD 'DsideaL147258369';
ALTER ROLE postgres SUPERUSER;


vi /usr/local/postgresql/data/postgresql.conf
listen_addresses = '*'


vi /usr/local/postgresql/data/pg_hba.conf
host all all 0.0.0.0/0 md5



# 启动脚本
# root

cat << EOF > /etc/systemd/system/postgresql.service
[Unit]
Description=postgresql project  
After=pgserver.service           

[Service]
Type=forking     
User=pgsql
Group=pgsql
ExecStart=/usr/local/postgresql/bin/pg_ctl start -D  /usr/local/postgresql/data
ExecReload=/usr/local/postgresql/bin/pg_ctl restart -D  /usr/local/postgresql/data
ExecStop=/usr/local/postgresql/bin/pg_ctl stop -D  /usr/local/postgresql/data
PrivateTmp=true  

[Install]
WantedBy=multi-user.target  

EOF



# 生效
systemctl daemon-reload

systemctl start postgresql.service
systemctl stop postgresql.service

#配置开机启动 
systemctl enable postgresql.service