novnov <novnovice(at)gmail(dot)com> writes:
> I am trying to connect to a postgres 8.1 installation on a ubuntu box from
> windows xp. I get this error: FATAL: missing or erroneous pg_hba.conf file
> HINT see server log for details.
>
> The server ip address is 192.168.1.10. The workstation ip address is
> 192.168.2.100. The server firewall allows connections on port 5432. I am
> past the 'is the server open on port 5432?' errors, now it's 'missing or
> erroneous pg_hba.conf'. I've added a line like this to that file:
>
> host all all 192.168.2.100 md5 (have tried trust also)
I think you need a netmask on this IP:
host all all 192.168.2.100/32 md5
-Doug