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$