postgis connection problem.

[Dave Potts]

I am trying to connect to postgres database on my local machine

The connect strings reads

CONNECTION "dbname=castle user=dave password=foobar host=localhost 
port=5432"

This gives an msPOSTGISLAyerOpen(): Query error, the reported error is 
"unknown hostname: localhost"

Doing a nslookup on localhost gives the expected answer off 127.0.0.1

Using the value 127.0.0.1 instead of the string localhost, gives the 
same error, but reporting the error unknown host name 127.0.0.1

A telnet session to localhost 5432 connects , therefore the database is 
running on localhost,  I am not having any problems resolving names.

A psql session to the database castle with the login dave and the 
password foobar works correctly


SO why the error, any suggestions ?

Dave.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dave.potts.vcf
Type: text/x-vcard
Size: 85 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070111/6ebbfa72/dave.potts.vcf