yum安装并初始化PG

获取yum源

从官网获取yum源，并安装rpm包

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

安装

yum install -y postgresql14-server

启动并初始化

sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl enable postgresql-14
sudo systemctl start postgresql-14
systemctl status postgresql-14

目录说明

默认情况下，数据目录在/var/lib/pgsql/14/data/
bin目录在/usr/pgsql-14/bin/

修改端口监听方式

/var/lib/pgsql/14/data/postgresql.conf

创建用户、数据库

su - postgresql

cd /usr/pgsql-14/bin/
./pg_ctl status
psql
create user pgadmin with password 'pgpasswd';
create database pgadmin;

修改acl规则，允许pgadmin用户远程访问

echo "host  all     pgadmin     0.0.0.0/0       scram-sha-256" >> /var/lib/pgsql/14/data/pg_hba.conf
./pg_ctl reload