Can't connect to PostgreSQL from external IP

Lukewalker18

I already installed firewall, added the port, allowed it and set DB permission to everyone. Rebooted the server but I still cant connect to the database with DB Admin tool. Connection timeout. Checked from the OS root with tulpn command, port are open.. Tried to change port to 5431, still cant remote it

aaP_pejcha1994

Hi there,

Postgres is a bit unique and you have to edit the configuration files in order to set which addresses it should listen to.

Here is a quide for Plesk, but the principle is the same: https://support.plesk.com/hc/en-us/articles/115003321434-How-to-enable-remote-access-to-PostgreSQL-server-on-a-Plesk-server-

Cheers!

Lukewalker18

aaP_pejcha1994 Solved the issue. Turns out, SYS Firewall from the App Store doesn't work properly.. I have to run this manually from terminal. Maybe aapanel team need to check SYS Firewall. It's buggy
firewall-cmd --permanent --add-port=5432/tcp firewall-cmd --reload