Initial Setup

--Locally as postgres

cd /var/lib/pgsql/data

cp postgresql.conf postgresql.conf.20190103

vi postgresql.conf

listen_addresses = '*' <---------------- by default is listen_addresses = 'localhost'

--Locally as root (restart PostgreSQL instance)

service postgresql stop

service postgresql start

--Locally as postgres

psql

postgres=# SHOW listen_addresses;

 listen_addresses

------------------

 *

postgres=# SHOW hba_file;

 hba_file

---------------------------------

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

--Locally as postgres

cd /var/lib/pgsql/data

cp pg_hba.conf pg_hba.conf.20190103

vi pg_hba.conf  <-------------- add following lines to pg_hba.conf

# 2019-01-03 Allow remote connections if the user's password is correctly supplied.

# TYPE  DATABASE        USER            ADDRESS                 METHOD

host    all             all              0.0.0.0/0               md5

host    all             all              ::/0                    md5

--Locally as root (restart PostgreSQL instance)

service postgresql stop

service postgresql start