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

Bistrais, Bob Bob.Bistrais at maine.gov
Thu Feb 16 11:44:35 EST 2012


Great!  Thanks Eli!

-----Original Message-----
From: Eli Adam [mailto:eadam at co.lincoln.or.us] 
Sent: Thursday, February 16, 2012 11:19 AM
To: Brent Fraser
Cc: Bistrais, Bob; Geomoose-users at lists.osgeo.org
Subject: Re: [Geomoose-users] Trouble with PostGis layer on GM 2.2

I tend to agree with Brent on why to select PostGIS.

If you are after performance, this page has lots of advice,
http://mapserver.org/optimization/index.html
I notice that shp2tile or tile4ms is no longer listed in the shapefile
optimization, http://www.mapserver.org/utilities/tile4ms.html

FCGI is probably one of the more useful.

HTH, Eli

On Thu, Feb 16, 2012 at 7:10 AM, Brent Fraser <bfraser at geoanalytic.com> wrote:
> 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
> 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
>
>
> _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/geomoose-users
>


More information about the Geomoose-users mailing list