[Geomoose-users] Trouble with PostGis layer on GM 2.2

[Bistrais, Bob]

Not yet, still fumbling with the Simplfy statement.  But, as was said,
it's not really appropriate to have the parcels display at that scale.
This is more of an experiment to see how well I can improve performance
with PostGIS over shapefiles.  Any advice is welcomed on that.

 

________________________________

From: Brent Fraser [mailto:bfraser at geoanalytic.com] 
Sent: Thursday, February 16, 2012 9:55 AM
To: Bistrais, Bob
Cc: Geomoose-users at lists.osgeo.org
Subject: Re: [Geomoose-users] Trouble with PostGis layer on GM 2.2

 

Cool.  Did you sort out your performance problems with the state-wide
parcel layer?




Best Regards,
Brent Fraser


On 2/16/2012 7:52 AM, Bistrais, Bob wrote: 

Yes, as it turns out, that's what I had to do and it's working now.

 

________________________________

From: Brent Fraser [mailto:bfraser at geoanalytic.com] 
Sent: Thursday, February 16, 2012 9:37 AM
To: Bistrais, Bob
Cc: Geomoose-users at lists.osgeo.org
Subject: Re: [Geomoose-users] Trouble with PostGis layer on GM 2.2

 

If your PostGIS server and mapserver are on different computers, make
sure you've enabled Postgres to accept remote connects (edit
pg_hba.conf).




Best Regards,
Brent Fraser


On 2/15/2012 12:50 PM, Bistrais, Bob wrote: 

Trying to implement some layers through PostGIS, and I'm a PG newbie
(some of you have seen my struggles on the other lists).  But now I am
having trouble displaying a layer in GeoMoose 2.2.  I think this may be
related to the MapServer version, as this same layer works fine with
MapServer 6.0.1

 

The error message is as follows:

msPOSTGISLayerOpen(): Query error. Couldn't make connection to DB with
connect string

 

The connection strings:

 

  DATA "the_geom from bb_connectme_rds USING SRID=26919 USING Unique
gid"

  CONNECTION "user=myusername password=mypassword dbname=postgistest
host=mymachinename port=5432"

  CONNECTIONTYPE postgis

  PROCESSING "CLOSE_CONNECTION=DEFER"

 

As I mentioned, this all works fine on another service using MapServer
6.0.1.  Does PostGis work with GM 2.2?  If so, does it look like my
connection strings are incorrect?





_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/geomoose-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20120216/7cc71216/attachment.html