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

[Brent Fraser]

Bob,

   Personally, I'd select PostGIS for data management reasons, not 
performance.  If you've got a few shapefiles a few thousand records and 
a spatial index (.qix), shapefiles will likely [slightly] out-perform 
PostGIS.

Best Regards,
Brent Fraser


On 2/16/2012 8:00 AM, Bistrais, Bob wrote:
>
> 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 
> <mailto: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  <mailto: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/120596ac/attachment-0001.html