Remote access from a client on LAN

[harvindersingh]

Hello

I am developing an application that requires PostgreSQL connection, I have installed PostgreSQL on my development machine and using NpgSQL to connect to the database. I am able to connect to the database while the application is running on the development PC, but whenever I am on any other PC on my network I cannot connect the application to the DB server running on another machine. I have been searching for a solution for quite a long time now, but nothing seems to be working.

I have tried editing the config files {pg_hba.conf and postgresql.conf } with the settings described in the following page:

http://www.cyberciti.biz/tips/postgr...onnection.html

pg_hba.conf:
I have inserted the following lines, just underneath the default loopback host string (host all all 27.0.0.0/32 md5):
host all all 192.168.0.0/24 trust

I have also tried a combination of things on the above string such as using md5 instead of trust and providing the actual ip address of the remote machine and so on, but no luck. As usual you would have to make changes to the other config file as well, see below

postgresql.conf :
I have uncommented the listen_addresse s='localhost' and changed localhost to '*':
listen_addresse s='*'

Nothing seems to be working, I would really appreciate if someone could put me in the right direction. Details on all the boxes are given below:

Developer machine: Windows XP PostgreSQL 8.XX installed
Other PC: Windows XP NO Postgresql installed
Other PC: Vista Home P with NO Postgresql installed

I have tried many things, such as turning the firewall off and so on, but nothing seems to be working.

NOTE: I am able to ping the PC with PostgreSQL installed both with Firewall on and off.

Thanks in advance.

[harvindersingh]

Nice to hear that your problem was also solved with disabling firewall. You also need to allow the IP address of the remotely connecting PC in order to allow the access through the firewall. I have mine firewalls up all times just added IP addresses of the remote PCs. the PC with the server should have Port access and all the IP addresses in its firewall and the remotely connecting PCs should also have the IP address of the DB server's PC as well.

Hope this helps, as mine works fine with the above settings, apparently it was working since I installed the server only firewall was messing with my connections and thank god I managed to find it.