Changes between Version 12 and Version 13 of UsersWikiPostGIS20Ubuntu1204
- Timestamp:
- 05/05/12 22:56:55 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UsersWikiPostGIS20Ubuntu1204
v12 v13 96 96 The end of the configure processing should leave you with something that looks like this: 97 97 {{{ 98 PostGIS is now configured for i686-pc-linux-gnu 99 100 -------------- Compiler Info ------------- 101 C compiler: gcc -g -O2 102 C++ compiler: g++ -g -O2 103 104 -------------- Dependencies -------------- 105 GEOS config: /usr/bin/geos-config 106 GEOS version: 3.3.3 107 GDAL config: /usr/bin/gdal-config 108 GDAL version: 1.9.0 109 PostgreSQL config: /usr/bin/pg_config 110 PostgreSQL version: PostgreSQL 9.1.3 111 PROJ4 version: 47 112 Libxml2 config: /usr/bin/xml2-config 113 Libxml2 version: 2.7.8 114 JSON-C support: yes 115 PostGIS debug level: 0 116 Perl: /usr/bin/perl 117 118 --------------- Extensions --------------- 119 PostGIS Raster: enabled 120 PostGIS Topology: enabled 121 122 -------- Documentation Generation -------- 123 xsltproc: /usr/bin/xsltproc 124 xsl style sheets: /usr/share/xml/docbook/stylesheet/nwalsh 125 dblatex: 126 convert: 127 mathml2.dtd: /usr/share/xml/schema/w3c/mathml/dtd/mathml2.dtd 98 128 }}} 99 129 … … 179 209 * Group: Servers [default] 180 210 181 182 183 211 == Spatially-enabling a database == 184 212 With PostgreSQL 9.1, there are two methods to add PostGIS functionality to a database: using extensions, or using enabler scripts. … … 189 217 Connect to your database using pgAdmin or psql, and run the following commands. To add postgis with raster support: 190 218 {{{ 191 CREATE EXTENSION postgis; 219 postgres=# CREATE EXTENSION postgis; 220 CREATE EXTENSION 221 postgres=# 192 222 }}} 193 223 194 224 To add topology support, a second extension can be created on the database: 195 225 {{{ 196 CREATE EXTENSION postgis_topology; 226 postgres=# CREATE EXTENSION postgis_topology; 227 CREATE EXTENSION 228 postgres=# 197 229 }}} 198 230