Can't access remote PostreSQL

Question

I just moved my office and now I can't get to PostgreSQL on my Windows web server.

I changed the pg_hba.conf file to the new IP address. I made no other changes to the server or my computer.

One known difference is that I am temporarily using a public xfinitywifi hotspot until my new cable internet is set up, which may be a few more days. And yes, I know this hotspot uses a dynamic IP, I am using WhatIsMyIP to get the IP to use in the pg_hba.conf.

Any ideas on how to resolve this? If WhatIsMyIP giving me the correct IP address to use in this context?

Thanks, Brad

@Hyppy, why would it do that and how? Is is blocking the port? — Brad Mathews, May 07 '15 at 20:07
It's a consumer-level hotspot. They block all sorts of stuff. — Hyppy, May 07 '15 at 20:07
I got my real internet connection and it still is not working. I emailed my ISP and they say the port is being filtered. My server firewall rule still looks good, so any ideas how it is getting filtered? — Brad Mathews, May 11 '15 at 19:27

score 0 · Answer 1 · answered May 11 '15 at 19:41

Turns out I had locked down which external IP address I could use within the firewall rule. So port 5432 was being seen as filtered from any other IP address.

Maybe that is overkill, using both the firewall and pg_hba.conf to limit access to a specific external IP address?

Brad

Can't access remote PostreSQL

1 Answers1