Postgresql – Pb connection from client to postgresql server

postgresql

I've no problem to access to postgresql server from local machine with two methods (localhost or specific ip ).
But when i try to connect from client machine to the postgresql server (in other pc using network lan), i have this error : can't connect to the server.
These steps were verified in computer which include postgresql server:

  • listen_adresses='*' ==> OK in postgresql.conf file
  • host all all 0.0.0.0/0 md5 => Ok in pg_hba.conf file
    _ postgresql rule is inserted in inbound windows firewall including these parameters : protocol type : TCP, local port: specific ports: 5432, action: allow connection, profiles: domain, private and public all checked
    I've verified with ping all it's ok
    but when I try to connect from client machine to postgresql server the problem persist.
    Thank you in advance for your answers!

Best Answer

I found the solution to my problem.

I've added ODBC to the client machine with IP server + allowing port 5432 and every thing ran fine.