Changes between Version 12 and Version 13 of UsersWikiPostGIS20Ubuntu1204


Ignore:
Timestamp:
May 5, 2012, 10:56:55 PM (12 years ago)
Author:
jeffmeyer
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • UsersWikiPostGIS20Ubuntu1204

    v12 v13  
    9696The end of the configure processing should leave you with something that looks like this:
    9797{{{
     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
    98128}}}
    99129
     
    179209 * Group: Servers [default]
    180210
    181 
    182 
    183211== Spatially-enabling a database ==
    184212With PostgreSQL 9.1, there are two methods to add PostGIS functionality to a database: using extensions, or using enabler scripts.
     
    189217Connect to your database using pgAdmin or psql, and run the following commands. To add postgis with raster support:
    190218{{{
    191 CREATE EXTENSION postgis;
     219postgres=# CREATE EXTENSION postgis;
     220CREATE EXTENSION
     221postgres=#
    192222}}}
    193223
    194224To add topology support, a second extension can be created on the database:
    195225{{{
    196 CREATE EXTENSION postgis_topology;
     226postgres=# CREATE EXTENSION postgis_topology;
     227CREATE EXTENSION
     228postgres=#
    197229}}}
    198230