安装PG

sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
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@liangcb ~]# su postgres
bash-4.2$ psql
could not change directory to "/root": Permission denied
psql (14.4)
Type "help" for help.

postgres=# alter user postgres with password 'nihao123@nihao';        //重置默认密码
ALTER ROLE
\q
exit退出
[root@liangcb ~]# vim /var/lib/pgsql/14/data/postgresql.conf        //允许远程

[root@liangcb ~]# vim /var/lib/pgsql/14/data/pg_hba.conf

systemctl restart postgresql-14.service

psql -h host -U user -d database -p port
[root@liangcb ~]# psql -h 127.0.0.1 -U postgres   -p 5432 
Password for user postgres: 
psql (14.4)
Type "help" for help.

postgres=#