- CentOS
/var/lib/pgsql/9.4/data/pg_hba.conf
host all all 0.0.0.0/0 password
/var/lib/pgsql/9.4/data/postgresql.conf
- #listen_addresses = 'localhost'
+ listen_addresses = '*'
$ sudo service postgresql-8.4 restart
or
$ sudo /etc/init.d/postgresql-9.4 restart-all
pgcli -h host -U postgres -p 5432