獲取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 - postgresqlcd /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