novnov <novnovice@xxxxxxxxx> 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
