CentOS7 PostgreSQL安装、配置、使用详解

# IPv4 local connections:
host  all       all       127.0.0.1/32      trust
host  all       all       192.168.117.1/32    trust
# IPv6 local connections:
host  all       all       ::1/128         trust

su postgres
psql -U postgres
ALTER USER postgres WITH PASSWORD 'P0stgres'
\q

<"1.0" encoding="utf-8"?>
<service>
    <short>Postgres 9.4 Database service</short>
    <description>Postgres</description>
    <portprotocol="tcp"port="5432"/>
</service>

firewall-cmd --permanent --add-service=postgres94
firewall-cmd --reload