PDA

View Full Version : trouble accessing across network



udbrky
09-29-2009, 03:16 AM
I've had my HEM DB shared over my LAN for over a year. Last week, I had major issues with it, and Fozzy had to uninstall and reinstall postgres and HEM like 10 times before he got it to run. We also uninstalled comodo firewall and finally everything worked fine.

Previously, to network, I had changed the end of my pg_hba file to this:



# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 192.168.0.1/32 trust
host all all 192.168.0.199 trust
# IPv6 local connections:
host all all ::1/128 trust
host all all 127.0.0.1/32 trust
host all all 192.168.0.1/32 trust
host all all 192.168.0.199 trust

Now, when I have that in the file, postgres will not start. If I change it back to normal, everything is fine.

Can anyone spot an error in what I'm doing? I've updated to 34, I'm using 8.4, but had 8.3 when I had the crash last week. I miss playing on my desktop with bigger monitors.

netsrak
09-29-2009, 03:20 AM
Thats a very specific question, i see no problems with this.

I suggest you try at www.postgresql.org or in their forums.

udbrky
10-04-2009, 03:38 PM
I finally got it - I got a response on a postgres forum finally. I needed this:

host all all 192.168.0.199/32 trust

netsrak
10-05-2009, 10:32 AM
Now i see it too :)

Thanks for the feedback