Install the repository RPM:

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

Install PostgreSQL:

sudo yum install -y postgresql14-server
sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl enable postgresql-14
sudo systemctl start postgresql-14

修改密码

[root@file data]# sudo su postgres
bash-4.2$ psql postgres
psql (14.5)
Type "help" for help.

postgres=# 

postgres=# \password postgres
Enter new password for user "postgres":
Enter it again:
postgres=#

允许外部连接

1、修改配置

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

添加

listen_addresses = '*'

2、编辑防火墙

vim /var/lib/pgsql/14/data/pg_hba.conf

添加

# TYPE  DATABASE        USER            ADDRESS                 METHOD
host    all             all             0.0.0.0/0               md5

3、开通系统防火墙

firewall-cmd --add-port=5432/tcp --permanent 
firewall-cmd --reload

4、重启服务

5、下载pgAdmin管理

https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v6.13/windows/pgadmin4-6.13-x64.exe