把最新的rpm包添加到系统库PostgreSQL会为所有的Linux平台发布rpm包, 而且会比其他的的库更新的更快.地址：postresSQL linuxrpm -Uvh https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm列出可用安装包yum list postgres安装PostgreSQLyum install -y postgresql11-server.x86_64初始化数据库/usr/pgsql-11/bin/postgresql-11-setup initdb 仅需执行一次启动PostgreSQLsystemctl start postgresql-11设置自启动systemctl enable postgresql-11查看运行状态systemctl status postgresql-11开机启动chkconfig postgresql-11 on重置密码1) sudo -u postgres psql2) ALTER USER postgres WITH PASSWORD ‘postgres’;3) 退出 \q开启远程访问vi /var/lib/pgsql/11/data/postgresql.conf修改#listen_addresses = ’localhost’ 为 listen_addresses=’’,建议只监听内网IP修改客户端认证配置文件pg_hba.confvi /var/lib/pgsql/11/data/pg_hba.conf将IPv4区下的127.0.0.1/32修改为0.0.0.0/0； 将ident修改为md5重启服务service postgresql-11 restart开放端口firewall-cmd –zone=public –add-port=5432/tcp –permanent重载防火墙firewall-cmd –reload