- Plesk for Linux
- The database creation on PostgreSQL server under Domains > example.com > Databases > Add Database fails with the following error:
PLESK_ERROR: The test connection to the database server has failed because of network problems: No route to host
- There are the following entries in
CONFIG_TEXT: ERR [panel] throw: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: No route to host
Is the server running on host "192.0.2.2" and accepting
TCP/IP connections on port 5432?
- PostgreSQL port is listened on the server:
# netstat -tln | grep 5432
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN
Firewall is blocking port 5432.
- Log in the server via SSH.
- Open the port using
# iptables -A INPUT -p tcp --dport 5432 -j ACCEPTOR
# firewall-cmd --permanent --add-port=5432/tcp
# firewall-cmd --add-port=5432/tcp
# firewall-cmd --reload