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.