PostGIS 2.0已经发布了，挺激动人心的。在12.04中集成了PostGIS 1.5.4，如果想用到一些新的特性，就不得不做出升级的选择。我们采用sharpie项目组的发布包进行部署。
首先，卸载掉原有的postgis和postgresql-9.1-postgis包。
sudo dpkg –purge postgis postgresql-9.1-postgis然后，，添加相应的repository并安装PostGIS.
sudo apt-add-repository ppa:sharpie/for-science # To get GEOS 3.3.2 sudo apt-add-repository ppa:sharpie/postgis-nightlysudo apt-get updatesudo apt-get install postgresql-9.1-postgis
接下来，创建模板库
createdb -E UTF8 template_postgiscreatelang -d template_postgis plpgsqlpsql -d postgres -c “UPDATE pg_database SET datistemplate=’true’ WHERE datname=’template_postgis'”psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.1/postgis.sqlpsql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.1/spatial_ref_sys.sqlpsql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.1/postgis_comments.sqlpsql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.1/rtpostgis.sqlpsql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.1/raster_comments.sqlpsql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.1/topology.sqlpsql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.1/topology_comments.sqlpsql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.1/legacy.sql最后，利用模板创建数据库就可以了
creatdb mydb -T template_postgis
参考内容：
1.部署内容参考
其原文内容如下
PostGIS 2.0 is out and the awesomness continues! You can install PostGIS 2.0 on Ubuntu using packages which is exactly what I am going to show you here. Read on for details on how to get up and running and do your first simple raster analysis!
Note: You should make good backups first!
Before we begin, you should uninstall your existing postgis packages:
sudo dpkg –purge postgis postgresql-9.1-postgisThen add a new repository and install PostGIS from there (based on this post):
sudo apt-add-repository ppa:sharpie/for-science # To get GEOS 3.3.2 sudo apt-add-repository ppa:sharpie/postgis-nightlysudo apt-get updatesudo apt-get install postgresql-9.1-postgisNext we should create a new template database (optional but recommended).
createdb -E UTF8 template_postgis2createlang -d template_postgis2 plpgsqlpsql -d postgres -c “UPDATE pg_database SET datistemplate=’true’ WHERE datname=’template_postgis2′”psql -d template_postgis2 -f /usr/share/postgresql/9.1/contrib/postgis-2.0/postgis.sqlpsql -d template_postgis2 -f /usr/share/postgresql/9.1/contrib/postgis-2.0/spatial_ref_sys.sqlpsql -d template_postgis2 -f /usr/share/postgresql/9.1/contrib/postgis-2.0/rtpostgis.sqlpsql -d template_postgis2 -c “GRANT ALL ON geometry_columns TO PUBLIC;”psql -d template_postgis2 -c “GRANT ALL ON geography_columns TO PUBLIC;”psql -d template_postgis2 -c “GRANT ALL ON spatial_ref_sys TO PUBLIC;”createdb training -T template_postgis2Ok now we can load a raster (see sample data download below):
raster2pgsql -s 4326 srtm_4326.tif | psql trainingshp2pgsql -s 4326 -d -g geom -I places.shp places| psql trainingGood – now our spatial database is ready to use – and has raster support! Here is a nice example of what you can do. The query looks up the altitude from the SRTM raster for each place listed using the ST_Value function:
select ST_Value(rast, geom, true) from places, srtm_4326;It should produce something like this:
Further reading: A really good place to start is the Boston GIS cheatsheets – I am really looking forward to exploring all the new features that are available in PostGIS 2.0, thanks to all those involved in building it!
Sample data for the example listed
—————————————————————————
2.创建空间数据库的说明 请参考
别想一下造出大海，必须先由小河川开始。
