yum install -y gcc make readline-devel zlib-devel libicu-devel
cd /usr/local
tar zxvf postgresql-12.16.tar.gz
cd postgresql-12.16
./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
##重启
/usr/local/postgresql/bin/pg_ctl -D /usr/local/postgresql/data -l logfile restart