CentOS 7 安装PostgreSQL 11.4后配置远程访问

sudo firewall-cmd --add-service=postgresql --permanent
sudo firewall-cmd --reload

vi /var/lib/pgsql/11/data/postgresql.conf 
listen_addresses = '*'

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

# Accept from anywhere
host all all 0.0.0.0/0 md5

# Accept from trusted subnet
host all all 192.168.18.0/24 md5

Restart service
sudo systemctl restart postgresql-11

Set PostgreSQL admin user’s password
$ sudo su - postgres 
bash-4.2$ psql -c "alter user postgres with password 'password'" 
ALTER ROLE
-bash-4.2$