Re: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem
Hi, Basically it means that the SQL query for getting the extents of your layer is slow. Set timing on with \timing on in your psql window and run query select st_extent(geom) from titles; http://postgis.refractions.net/docs/ST_Extent.html How long does it take? Do vacuum analyze for the table and try again to see if there has been some trouble with indexes. Anyway, it is always faster to get extents from the metadata line than from PostGIS, but normally it should not take very long. For me it takes 1500 ms with a table of 30 polygons. -Jukka Rahkonen- > -Alkuperäinen viesti- > Lähettäjä: mapserver-users-boun...@lists.osgeo.org > [mailto:mapserver-users-boun...@lists.osgeo.org] Puolesta anddreas2 > Lähetetty: 22. syyskuuta 2011 8:52 > Vastaanottaja: mapserver-users@lists.osgeo.org > Aihe: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem > > I found the solution: > > Just set THE wms_extent METADATA in the layer section and it > works. Without > Layers wms_extent it crashes. > > (Jesus, I spent three days of my life for this stupid thing. > I tested with > all versions of postgis (1.5, 1.4) postgresql (8.4,9.0,9.1). > I am think it > is ms4w problem). > > -- > View this message in context: > http://osgeo-org.1803224.n2.nabble.com/Mapserver-6-WMS-PostGIS > -Problem-tp6387007p6819004.html > Sent from the Mapserver - User mailing list archive at Nabble.com. > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem
Does avoiding the WMS/OWS side and doing a CGI request using 'mode=map' produce a different result? P. On Wed, Sep 21, 2011 at 7:27 AM, Rob McCulley wrote: > Unfortunately not. I tried using the debugging tools available, but because > the cgi just hangs, there are no errors reported. I tried a fresh install, > with the same problem. > > Beyond that, I haven't had time to look into it any further. I'm still > running 5.6 as a result. > > Rob > > -Original Message- > From: mapserver-users-boun...@lists.osgeo.org > [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of anddreas2 > Sent: September-21-11 1:39 AM > To: mapserver-users@lists.osgeo.org > Subject: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem > > Hi > > I have the same problem. Did you find any solution? > > > > -- > View this message in context: > http://osgeo-org.1803224.n2.nabble.com/Mapserver-6-WMS-PostGIS-Problem-tp6387007p6815163.html > Sent from the Mapserver - User mailing list archive at Nabble.com. > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem
Unfortunately not. I tried using the debugging tools available, but because the cgi just hangs, there are no errors reported. I tried a fresh install, with the same problem. Beyond that, I haven't had time to look into it any further. I'm still running 5.6 as a result. Rob -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of anddreas2 Sent: September-21-11 1:39 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Re: Mapserver 6 WMS / PostGIS Problem Hi I have the same problem. Did you find any solution? -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Mapserver-6-WMS-PostGIS-Problem-tp6387007p6815163.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
