0

I'm getting Server doesn't listen (Img1) every time a try to connect to db server in pgAdmin III. It started after a network adjustment related to local machines IP number in our company.

I'm also receiving Error connecting to the server. (Img2)

Img1

Img2

Here's pg_hba.conf file and the ip adress of the computer.

enter image description here

Thiago Resende
  • 177
  • 1
  • 1
  • 8
  • 1
    Have you checked whether the ip addresses in the `pg_hba.conf` are still valid? – Jim Jones Jun 20 '18 at 12:51
  • the file `pg_hba.conf` is as in the image. – Thiago Resende Jun 20 '18 at 13:45
  • 1
    Are server and client in the same machine? If not, try to add this line to your pg_hba : `host all all 10.10.13.233/24 md5`. Afterwards, either restart the database or execute this function `SELECT pg_reload_conf()`. – Jim Jones Jun 20 '18 at 13:57
  • 1
    also make sure the `listen_addresses` at the `postgresql.conf` is properly configured, e.g. `listen_addresses = '*'` – Jim Jones Jun 20 '18 at 13:59
  • They're not in the same machine. I added the line and restarted my machine, but, unfortunately, the problem still goes on. Also checked the `postgresql.conf`. – Thiago Resende Jun 20 '18 at 14:44
  • 1
    That's puzzling. If the ip addresses are properly added to the pg_hba and the server is listening `*`, the only option that crosses my mind would be that there is a firewall not letting your connection to go through... which has happened to me many times before. – Jim Jones Jun 20 '18 at 14:47
  • Yes, and windows firewall is down. Do you think the problem may be coming from the *db* server that i'm trying to connect with? Would be valid to restart it or something? – Thiago Resende Jun 20 '18 at 17:02
  • 1
    It's hard to tell, since I have no access to your network. But I do recall having the same issue to establish a connection with postgres and the problem was actually in the firewall. Restart wouldn't help much, if the firewall rules are not allowing you to reach the server from your station. – Jim Jones Jun 21 '18 at 06:41

0 Answers0