Trying to get my postgresql database to be accessible from remote host.
Ive added firewall rule:
Code:
iptables -I INPUT 5 -m state --state NEW -p tcp --dport 5432 -j ACCEPT
and edited the pg_hba.conf file to specify:
Code:
host    all             all             10.0.0.0/16             md5
However, remote host doesn't see any listener on the port:
Code:
telnet 10.0.3.10 5432
Trying 10.0.3.10...
telnet: connect to address 10.0.3.10: Connection refused
I tried to add
Code:
listen_addresses = '*'
to the postgresql.conf file, but then it won't restart successfully.
Code:
# service postgresql-10 restart
Stopping postgresql-10 service:                            [  OK  ]
Starting postgresql-10 service:                            [FAILED]