Wonderful, that solved it...THANK YOU! Douglas McNaught wrote: > > 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 > > ---------------------------(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.
