I have a problem when I tried to remote PostgreSQL Server (in Linux Centos) from my PgAdmin Client (in Windows), there’s an error message displayed on screen said “could not connect to server: connection timed out (0x0000274c/10060) is the server running on host and accepting tcp/ip connections on port 5432?”
I checked my firewall status with :
systemctl status firewalld
It said that my firewall status was Active: failed. From here I’m sure there’s problem with my firewall process, because if the firewall stopped successfully, the status will be inactive like this image below :
SOLUTION
After tried many solution, I ended-up with this one :
systemctl unmask firewalld
Next step after run unmask syntax, I tried to restart my firewall and it runs flawlessly :). Hope this thread help you guys.
It works!!!
Those stubborn people in forum keep saying pg_hba.conf and listen address blah blah blah….
But you, my friend. You just saved my project.
Oh man, thank you for this solution.
Have a good day, sir!
*throws cendol*
Very happy it helped you 🙂
Hi, I am trying to connect postgresql windows server to windows client and getting same error.
Can you tell me what command to run to check firewall in windows?
Just go to firewall setting in control panel