You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
75 lines
1.5 KiB
75 lines
1.5 KiB
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
|
|
|