linux - Unable to connect to PostgreSQL server: could not connect to server: Permission denied

Question

Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Permission denied Is the server running on host "10.0.1.201" and accepting TCP/IP connections on port 5432?

This is the error i am getting when trying to connect to remote database from linux based server

Though i am able to connect to it from localhost

Can anyone help me in this

Answer 1

One possible scenario/solution that worked for me (for the very same problem) is here:

service httpd stop
service postgresql stop

setsebool -P httpd_can_network_connect 1

service httpd start
service postgresql start

Here we're basically allowing HTTPD to connect to PostgreSQL over network by setting SELinux bool equals to 1 (true).