"missing or erroneous pg_hba.conf file"

[scratch28]

I'm trying to setup my laptop to access the database on my desktop over my home network. I had no problems with PT2 doing this but can't seem to get it working with HEM. I followed the steps EXACTLY according to the tutorial and am now getting a msg that says:

Connection Error: Unable to read data from the transport connection. An existing connection was forcibly closed by the remote host.

then when i try again it says...

Connection Error: FATAL: F0000: missing or erroneous pg_hba.conf file
followed by a bunch of details...

One side note...when i changed the pg_hba.conf file to allow the ip of my laptop to connect, the changes show up if i open that file in notepad but do NOT show up if i open it thru pgadminIII

[morny]

Im not familiar with that error to be honest, maybe try repeating the process and if the problem persists try posting on the PostgreSQL forum about that error or maybe try exporting the hands, doing a fresh install and when you get it up and running reimport the hands

[Crazyeyez]

FWIW I had the same issue. I slapped a "/32" on the end of the ip address in the pg_hba.conf file and now I'm in business. I don't know what that means but I found it via google in another sql forum.

Good luck.

[Papa Cheche]

Thanks, i had the same problem. with /32 , it's now OK :-)

[Sept]

Damn... I have the exact same problem, but it wasn't fixed by adding the '/32' :/

Here's how my pg_hba.conf looks like :

# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 192.168.1.0/32 md5
# IPv6 local connections:
host all all ::1/128 trust

Please help !!!

[Papa Cheche]

stop and restart the service

[Sept]

Did that about a couple dozen times already

[netsrak]

Please try another ip address.
I think 192.168.1.0 is not valid. You should use the exact IP of your 2nd computer

[_Loki_]

Like Karsten says...

to find your ip addresses in xp use ipconfig in cmd - look here for examples:
Windows 2000 / XP TCP/IP protocol
& here
Windows XP ipconfig Tutorial
(but the comments about resnet are particular to the user)

Maybe the procedure is diff in other OS, but easy to find if you google ipconfig & your OS

[Sept]

Please try another ip address.
I think 192.168.1.0 is not valid. You should use the exact IP of your 2nd computer

I love you! That did the trick, everything working fine now. Thanks so much!

On a side note, the "192.168.1.0" came from your faq page : "add a line like host/all/postgres/192.168.2.0 (= address of your local network)/md5 if your laptop is getting an IP Adres from a DHCP server within your network."

My laptop indeed is getting its IP from DHCP. Maybe someone should edit that line if it doesn't work?

Thanks again.