Centos8-stream安装PostgreSQL13

yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install -y postgresql13-server

mkdir /home/pgsql-13
chmod 777 /home/pgsql-13  #授予权限，否则后续初始化是会报错

su postgres     
/usr/pgsql-13/bin/initdb -D /home/pgsql-13/data

cd  /home/pgsql-13
/usr/pgsql-13/bin/pg_ctl -D /home/pgsql-13/data -l logfile start

vi /home/pgsql-13/data/postgresql.conf
listen_addresses = ‘localhost’   #开放本地登录
port = 5432          #开放登录端口
psql
ALTER USER postgres WITH PASSWORD '（123456）'; #将123456替换成自己设定的数据库密码
CREATE DATABASE mytest;  #创建数据库
\q  #退出操作

vi /home/pgsql-13/data/pg_hba.conf
host       all       all        0.0.0.0/0      md5  #结尾处添加

mkdir /home/pgsql-13/bin
vi /home/pgsql-13/bin/startup.sh

#! /bin/bash
su postgres<<!
cd /home/pgsql-13
/usr/pgsql-13/bin/pg_ctl -D /home/pgsql-13/data -l logfile start
exit $?
!

chmod -R 755 startup.sh
vi /etc/rc.local
/home/pgsql-13/bin/startup.sh #在文件内容最后一行添加

mkdir -p /home/pgsql-13/backdata
chmod 777 /home/pgsql-13/backdata
mkdir -p /home/pgsql-13/backdata/bin
vi  /home/pgsql-13/backdata/bin/backup.sh

#! /bin/bash
t=KaTeX parse error: Expected group after '_' at position 112: …ip > backupfile_̲t.sql.gz
find /home/pgsql-13/backdata -mtime 7 -type f|xargs rm -f
exit $?
!

12 2 * * * /home/pgsql-13/backdata/bin/backup.sh

sudo vi .bash_profile
PGDATA=/home/pgsql-13/data
PATH=/usr/local/src/postgresql/pgsql/bin:/usr/pgsql-13/bin
export PGDATA PATH
sudo . .bash_profile