Wonderful, that solved it...THANK YOU!
Douglas McNaught wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
--
View this message in context:
http://www.nabble.com/Connecting-to-a-remote-server%2C-pg_hba.conf-error--tf3297991.html#a9175269
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
