[OSGeo-Discuss] PostGIS security releases 2.0.6 and 2.1.3
It has come to our attention that the PostGIS Raster support may give more privileges to users than an administrator is willing to grant. These include reading files from the filesystem and opening connections to network hosts. Both issues can be limited in existing installations by setting the GDAL_SKIP variable (in the PostgreSQL server environment) to the list of all gdal drivers, but some drivers would still be forceably loaded by some operations. Releases 2.1.3 and 2.0.6 strengthen the code to load no drivers by default and allows for a fine-grained tuning of what's allowed and what not through postgis-specific environment variables: - POSTGIS_GDAL_ENABLED_DRIVERS Specifies a list of GDAL drivers to _enable_ (rather than _skip_) By default all drivers are disabled. Example value: "GTiff PNG JPEG" - POSTGIS_ENABLE_OUTDB_RASTERS Enables read support for out-db raster bands if set to 1. By default out-db raster bands reading is disabled. Upgrade is highly recommended, especially for online services allowing users to run arbitrary SQL queries. Source downloads: http://download.osgeo.org/postgis/source/postgis-2.0.6.tar.gz MD5: ba6fc0a3f13b86e83cd8db1532110636 http://download.osgeo.org/postgis/source/postgis-2.1.3.tar.gz MD5: 104e4468429ea0882259fc268c62d6c7 Special thanks to Even Rouault for bringing up the issue and giving advice on its resolution. --strk(on behalf of the PostGIS Project Steering Committee) http://postgis.net ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
[OSGeo-Discuss] any spatial databases for high performance geo-computing
Hi All, sorry for asking, but what do you think is a good choice of spatial database for high performance geo-computing? In some high performance computing scenarios, data size tends to be huge, and a bunch of computer clusters work together with high throughput and tense computation. sometimes we use parallel filesystems like lustre, gfs, hdfs to handle specific problems but what if a spatial database? I explored some of postgresql cluster solutions, such as streaming replication, pgpool, slony and so on. I think most of them are designed for failover, and they might not be able to stand up with the huge data size and high performance demands. the case is quite alike in oracle and db2 spatial, i think. so any suggestions for projects aiming to build a distributed and parallel spatial database running on a cluster? Thanks, shuai ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] any spatial databases for high performance geo-computing
On 05/19/2014 03:04 PM, Zhang, Shuai wrote: > Hi All, > > sorry for asking, but what do you think is a good choice of spatial database > for high performance geo-computing? > > In some high performance computing scenarios, data size tends to be huge, and > a bunch of computer clusters work together with high throughput and tense > computation. sometimes we use parallel filesystems like lustre, gfs, hdfs to > handle specific problems but what if a spatial database? > > I explored some of postgresql cluster solutions, such as streaming > replication, pgpool, slony and so on. I think most of them are designed for > failover, and they might not be able to stand up with the huge data size and > high performance demands. the case is quite alike in oracle and db2 spatial, > i think. > > so any suggestions for projects aiming to build a distributed and parallel > spatial database running on a cluster? > > Thanks, > shuai I haven't used but have a seen a few Hadoop implementations. If you do research on Sharding that's the kind of db where the data is split across nodes not redundantly. http://www.nathankerr.com/projects/parallel-gis-processing/alternative_approaches_to_parallel_gis_processing.html http://www.ncbi.nlm.nih.gov/pmc/articles/PMC3814183/ Then of course depending on your needs there are plenty of MPI compatible libraries in various languages. Thanks, Alex ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] any spatial databases for high performance geo-computing
Tools like Hadoop, Neteeza & Teradata support very large databases & are fully spatially aware, generally through custom re-implementations of FOSS tools like GDAL. http://www10.giscafe.com/nbc/articles/view_article.php?articleid=590803 http://www.teradata.com.au/products-and-services/teradata-geospatial or in the FOSS arena: http://spatialhadoop.cs.umn.edu/ Brent Wood On 05/19/2014 03:04 PM, Zhang, Shuai wrote: > Hi All, > > sorry for asking, but what do you think is a good choice of spatial database > for high performance geo-computing? > > In some high performance computing scenarios, data size tends to be huge, and > a bunch of computer clusters work together with high throughput and tense > computation. sometimes we use parallel filesystems like lustre, gfs, hdfs to > handle specific problems but what if a spatial database? > > I explored some of postgresql cluster solutions, such as streaming > replication, pgpool, slony and so on. I think most of them are designed for > failover, and they might not be able to stand up with the huge data size and > high performance demands. the case is quite alike in oracle and db2 spatial, > i think. > > so any suggestions for projects aiming to build a distributed and parallel > spatial database running on a cluster? > > Thanks, > shuai___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] any spatial databases for high performance geo-computing
Two options for distributed spatial databasing, based on Solr's spatial types: ElasticSearch: http://www.elasticsearchtutorial.com/spatial-search-tutorial.html Riak: http://www.christopherbiscardi.com/2014/02/07/geospatial-indexing-with-riak-search-2-0-yokozunasolr/ I've had great success with ElasticSearch and spatial search, but not in a clustered configuration. Riak is designed from the ground up to be a distributed database, but its Solr support is quite new and still in beta. Neither one support particularly complex geometric operations AFAIK, so YMMV. Good luck! SDE On May 19, 2014, at 3:04 PM, "Zhang, Shuai" wrote: > Hi All, > > sorry for asking, but what do you think is a good choice of spatial database > for high performance geo-computing? > > In some high performance computing scenarios, data size tends to be huge, and > a bunch of computer clusters work together with high throughput and tense > computation. sometimes we use parallel filesystems like lustre, gfs, hdfs to > handle specific problems but what if a spatial database? > > I explored some of postgresql cluster solutions, such as streaming > replication, pgpool, slony and so on. I think most of them are designed for > failover, and they might not be able to stand up with the huge data size and > high performance demands. the case is quite alike in oracle and db2 spatial, > i think. > > so any suggestions for projects aiming to build a distributed and parallel > spatial database running on a cluster? > > Thanks, > shuai > ___ > Discuss mailing list > Discuss@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss