[mapserver-users] ogr connection to postgis problems

[Jeff McKenna]

Travis Kirstine wrote:
> I am trying to test a connection to a postgis db  using ogrinfo and am
> having difficulties.  I am running the command on the same server that
> hosts the postgis db.  I checked the pg_hba.config file to see if it
> allows local connections and everything looks OK but I still get
> "Failure" when connecting with ogr.
> 
> Am I missing something?
> 
> 
> command
> ogrinfo -ro PG:'host=server34 dbname=earth user=bob password=suruncle'
> 
> 

My thoughts:

- since you are on the same server, use host=127.0.0.1
- include the port parameter (usually port=5432)

-jeff




-- 
Jeff McKenna
FOSS4G Consulting and Training Services
http://www.gatewaygeomatics.com/