Re: Connecting to a remote server, pg_hba.conf error?

novnov <novnovice@gmail.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