yum install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm
yum install postgresql11
yum install postgresql11-server
/usr/pgsql-11/bin/postgresql-11-setup initdb

systemctl enable postgresql-11 #设置开机启动
systemctl start postgresql-11 #启动服务

su - postgres
psql -U postgres
ALTER USER postgres with encrypted password 'yourpassword';
\q #退出数据库命令行
exit #退出bash

firewall-cmd --zone=public --add-port=5432/tcp --permanent
firewall-cmd --reload
firewall-cmd --list-ports

iptables -A INPUT -p tcp --dport 5432 -j ACCEPT
service iptables save
service iptables reload

vi /var/lib/pgsql/11/data/postgresql.conf

listen_addresses = 'localhost'

listen_addresses = '*'

vi /var/lib/pgsql/11/data/pg_hba.conf

systemctl restart postgresql-11