Changes between Version 3 and Version 4 of UsersWikiPostGIS20Ubuntu1110src

Timestamp:

04/03/12 00:54:25 (13 years ago)

Author:

Mike Taves

Comment:

remove some prerequisite packages; add extensions

UsersWikiPostGIS20Ubuntu1110src

@@ -6 +6 @@
 Install prerequisite packages using:
 {{{
-sudo apt-get install build-essential postgresql-9.1 postgresql-server-dev-9.1 libxml2-dev proj libjson0-dev
+sudo apt-get install build-essential postgresql-9.1 postgresql-server-dev-9.1 libxml2-dev proj libjson0-dev xsltproc docbook-xsl docbook-mathml
 }}}
 
-Optional package for raster support:
+Optional package for raster support (this is required if you want to build the PostgreSQL extensions):
 {{{
 sudo apt-get install libgdal-dev
 }}}
-
-Optional packages for testing PostGIS:
-{{{
-sudo apt-get install libcunit1-dev
-}}}
-Optional packages for building documentation:
-{{{
-sudo apt-get install xsltproc docbook-xsl docbook-mathml imagemagick
-}}}
-(for building PDF documentation, add `dblatex`, but expect a large download)
 
 === Build GEOS 3.3.x ===
@@ -29 +19 @@
 There are multiple ways to build GEOS, but this is the simplest:
 {{{
-wget http://download.osgeo.org/geos/geos-3.3.2.tar.bz2
-tar xvfj geos-3.3.2.tar.bz2
-cd geos-3.3.2
+wget http://download.osgeo.org/geos/geos-3.3.3.tar.bz2
+tar xvfj geos-3.3.3.tar.bz2
+cd geos-3.3.3
 ./configure
 make
@@ -40 +30 @@
 == Build PostGIS ==
 {{{
-wget http://postgis.refractions.net/download/postgis-2.0.0beta4.tar.gz
-tar xfvz postgis-2.0.0beta4.tar.gz
-cd postgis-2.0.0beta4
+wget http://postgis.refractions.net/download/postgis-2.0.0rc2.tar.gz
+tar xfvz postgis-2.0.0rc2.tar.gz
+cd postgis-2.0.0rc2
 }}}
-PostGIS 2.0 can be configured to disable topology or raster extensions, using the configure flags `--without-raster` and `--without-topology`. The default is to build both extensions:
+
+PostGIS 2.0 can be configured to disable topology or raster components, using the configure flags `--without-raster` and/or `--without-topology`. The default is to build both extensions. Note that raster is required for the extension installation method for PostgreSQL.
 {{{
 ./configure
@@ -60 +51 @@
 }}}
 
-== Template ==
-Complete a post-install by creating a template, which can be re-used for creating multiple spatially-enabled databases. Or if you just want to make one spatially enabled database, you can modify the commands for your needs.
+== Spatially enabling a database ==
+With PostgreSQL 9.1, there are two methods to add PostGIS functionality to a database: using extensions, or using enabler scripts.
+
+=== PostGIS Extension for PostgreSQL ===
+Spatially enabling a database using extensions is a new feature of PostgreSQL 9.1.
+
+Connect to your database using pgAdmin or psql, and run the following commands. To add postgis with raster support:
+{{{
+CREATE EXTENSION postgis;
+}}}
+
+To add topology support, a second extension can be created on the database:
+{{{
+CREATE EXTENSION postgis_topology;
+}}}
+
+== Enabler Scripts / Template ==
+
+Enabler scripts can be used to either build a template, or directly spatially enable a database. This method is older than the extension method, but is required if the raster support is not built.
+
+The following example creates a template, which can be re-used for creating multiple spatially-enabled databases. Or if you just want to make one spatially enabled database, you can modify the commands for your needs.
+
+PostGIS:
 {{{
 sudo -u postgres createdb template_postgis
@@ -69 +81 @@
 }}}
 
-=== Enable raster extension ===
-Adding on to `template_postgis`:
+with raster support:
 {{{
 sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.0/rtpostgis.sql
@@ -76 +87 @@
 }}}
 
-=== Enable topology extension ===
-Adding on to `template_postgis`:
+with topology support:
 {{{
 sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-2.0/topology.sql