Re: [postgis-users] release of 2.0?
Il giorno ven, 08/04/2011 alle 17.40 +, fork ha scritto: > I find running the current version via SVN to be not very painful, and worth > trying if you need a special function. Yes, I know, I'm using it - I just need an stable release for production and more, and I have to do some planning. Thanks. -- http://www.faunalia.it/pc ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] release of 2.0?
Paolo et al, Just to add to this. Here is what we have for roadmap. http://trac.osgeo.org/postgis/milestone/PostGIS%202.0.0 I think we are on target for someitme late May to Mid June barring no acts of outside influences slowing us down.. If people close out their tickets perhaps things would move a bit faster.I think some of the tickets on this list are done deals and just require some outstanding testing etc before they are closed out. I'm beginning to close out the ones I've verified are done. Thanks, Regina -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paolo Cavallini Sent: Friday, April 08, 2011 7:00 AM To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] release of 2.0? Il giorno ven, 08/04/2011 alle 12.58 +0200, Olivier Courtin ha scritto: > Last discussion on this topic with Paul on Montreal Sprint was: > - May for a freeze > - to be able to release before FOSS4G Oh! Much later than I hoped - too bad. Thanks. -- http://www.faunalia.it/pc ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Postgis Installation Error
Hi Jorge, I am creating the db in the same way as you said and I am able to login into template_postgis db backend. since I am getting many notices about some functions and aggregates not exist, Can you tell me how to get them. Thanq once again -- View this message in context: http://old.nabble.com/Postgis-Installation-Error-tp31336778p31355915.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] release of 2.0?
Paolo Cavallini faunalia.it> writes: > Oh! Much later than I hoped - too bad. > Thanks. I find running the current version via SVN to be not very painful, and worth trying if you need a special function. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Strange problem building postgis 1.4.2 with geos
On 07/04/11 18:50, Bryan Montgomery wrote: I'm probably missing something simple. However I've been looking at this for a few hours scratching my head. First of, I know it's old versions we're using, I'm hoping to upgrade everything to the latest but We're trying to upgrade a version of geos, so we built and installed the next version of geos. geos-config --version reports 3.1.1. Ok, so far, running configure: PostGIS is now configured for x86_64-unknown-linux-gnu -- Compiler Info - C compiler: gcc -g -O2 C++ compiler: g++ -g -O2 -- Dependencies -- GEOS config: /usr/local/bin/geos-config GEOS version: 3.1 PostgreSQL config:/usr/local/pgsql/bin/pg_config PostgreSQL version: 8.2 PROJ4 version:46 PostGIS debug level: 0 All looks good, so we build ... PostGIS was built successfully. Ready to install. That's strange. Could it be a permissions problem? Does "make clean" remove postgis/libpostgis-1.4.so? If so, do a configure, make and then "make install" and check again. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] (no subject)
On 07/04/11 17:57, Paul & Caroline Lewis wrote: DB SIZE PROBLEM: I have run the following tests on a Postgresql 9 with postgis 1.5 platform and am getting significant table and index size differences. TestSet1 is run with a file tunnel6.asc, a CSV file with the following being a sample of the data: -6.34223029,53.39211958,132.586 The file is 6 GB in size with 70 million rows. After running TestSet1 the table has the correct number of rows (70 mill), random viewing of the data and it seems fine, while the table size is 16 GB and the index size is 6195 MB. I now Drop Cascade the tunnel6 table for TestSet2 For TestSet2 it is run on a preprocessed version of tunnel6.asc, now called tunnel6_py.asc, with the following being a sample of the data: -6.34223029,53.39211958,132.586,SRID=4326;POINT(-6.34223029 53.39211958 132.586) This file grows to 8 GB and still has 70 million rows but after following TestSet2 steps while the table still has the correct number of rows (70 mill), random viewing of the data and it still seems fine but now the table size is 9.5 GB and the index size is 3363 MB. Have I done something significantly wrong in these tests? The TestSet2 process loads the data about 10 minutes quicker than TestSet1 so I would like to use it but I don't trust it now given the significant differences in table sizes. Hi Paul, Due to the way in which the GiST indexes work, the order in which data is fed into the index build function can have a noticeable effect on the size and performance of the resulting index. This is because depending upon the order, page splits can occur at different points in the build process and hence influence the overall structure of the index. There has been some talk of optimising the split function to create better indexes, but no-one has really spent much time on it. That said, it appears that whatever you do in your pre-processing does have a noticeable performance benefit so if you can provide us with information as to how this pre-processing affects the order of the data then we may be able to make use of this information. ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] release of 2.0?
Il giorno ven, 08/04/2011 alle 12.58 +0200, Olivier Courtin ha scritto: > Last discussion on this topic with Paul on Montreal Sprint was: > - May for a freeze > - to be able to release before FOSS4G Oh! Much later than I hoped - too bad. Thanks. -- http://www.faunalia.it/pc ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] release of 2.0?
On Apr 8, 2011, at 12:45 PM, Paolo Cavallini wrote: Hi Paolo, Any news about a likely time frame for the release of 2.0? All the best. Last discussion on this topic with Paul on Montreal Sprint was: - May for a freeze - to be able to release before FOSS4G It was an informal discussion, but give the general idea. -- Olivier ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] release of 2.0?
Hi all. Any news about a likely time frame for the release of 2.0? All the best. -- http://www.faunalia.it/pc ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] postgis so slow-help
Hello, On Fri, Apr 8, 2011 at 6:04 AM, Eman Sayed wrote: > hello, > i am using mapserver for windows (ms4w) > ,postgres9.0,postgis2.0 and pmapper template > > after i successed to add one raster layer,the website become so slow > how to solve this problem while i want to add more raster layers? > > thanks > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > Are you loading raster layers from PostGIS Raster? If so, the slowness is a known issue, related with GDAL PostGIS Raster driver. -- Jorge Arévalo Internet & Mobilty Division, DEIMOS jorge.arev...@deimos-space.com http://es.linkedin.com/in/jorgearevalo80 http://mobility.grupodeimos.com/ http://gis4free.wordpress.com http://geohash.org/ezjqgrgzz0g ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Postgis Installation Error
Hi, On Thu, Apr 7, 2011 at 11:26 PM, vikashvikky wrote: > > > Hi Jorge, > > Thanx for your reply. I have tried what you said, this time its somewhat > better than previous but still some problem, When I make check I am getting > > > unning tests > > loader/Point.. ok > loader/PointM.. ok > loader/PointZ.. ok > loader/MultiPoint.. ok > loader/MultiPointM.. ok > loader/MultiPointZ.. ok > loader/Arc.. ok > loader/ArcM.. ok > loader/ArcZ.. ok > loader/Polygon.. ok > loader/PolygonM.. ok > loader/PolygonZ.. ok > regress. ok > regress_index. ok > regress_index_nulls. ok > lwgeom_regress. ok > regress_lrs. ok > removepoint. ok > setpoint. ok > simplify. ok > snaptogrid. ok > affine. ok > wkt. ok > measures. ok > long_xact. ok > ctors. ok > sql-mm-serialize. ok > sql-mm-circularstring. ok > sql-mm-compoundcurve. ok > sql-mm-curvepoly. ok > sql-mm-general. ok > sql-mm-multicurve. ok > sql-mm-multisurface. ok > geojson. ok > gml. ok > svg. ok > kml. ok > in_gml. ok > in_kml. ok > regress_ogc. ok > regress_ogc_cover. ok > regress_ogc_prep. ok > regress_bdpoly. ok > regress_proj. ok > dumppoints. ok > wmsservers. ok > tickets. failed (diff expected obtained: /tmp/pgis_reg_6910/test_47_diff) > regress_buffer_params. ok > hausdorff. ok > > Run tests: 49 > Failed: 1 > make[1]: Leaving directory `/sources/postgis/postgis-1.5.0SVN/regress' > > And getting the same error when I try to create template_postgis db. > -- > View this message in context: > http://old.nabble.com/Postgis-Installation-Error-tp31336778p31346600.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > The tickets problem is normal, but I think it has been solved in one of the last commits. Update your working copy first (svn update), compile and check again. About creating the new database, did you follow the steps in the same order? First create empty db, install PL/pgSQL, install PostGIS. In which step are you stuck? Anyway, in your log output I only see NOTICE messages, not errors. Could you try this, from a console? psql -U postgres -d template_postgis If you connect to your postgres backed, the database has been correctly created. Best regards, -- Jorge Arévalo Internet & Mobilty Division, DEIMOS jorge.arev...@deimos-space.com http://es.linkedin.com/in/jorgearevalo80 http://mobility.grupodeimos.com/ http://gis4free.wordpress.com http://geohash.org/ezjqgrgzz0g ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
