Changes between Version 13 and Version 14 of UsersWikiPostGIS20Ubuntu1204

Show
Ignore:
Timestamp:
05/05/12 23:03:16 (13 months ago)
Author:
jeffmeyer
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UsersWikiPostGIS20Ubuntu1204

    v13 v14  
    204204 * Maintenance DB: postgres [default] 
    205205 * Username: postgres 
    206  * Password: whatever you set in the prior step 
     206 * Password: whatever you set in the prior step - note that this is the PostgreSQL password and not the system password 
    207207 * Store password: uncheck this (or not, based on your security paranoia level) 
    208208 * Colour: whatever suits your fancy 
     
    215215Spatially enabling a database using extensions is a new feature of PostgreSQL 9.1. 
    216216 
    217 Connect to your database using pgAdmin or psql, and run the following commands. To add postgis with raster support: 
    218 {{{ 
    219 postgres=# CREATE EXTENSION postgis; 
     217Connect to a database using pgAdmin or psql, and run the following commands. For example, if you have created a database called 'GIStest', to add postgis with raster support capability to 'GIStest' do the following: 
     218{{{ 
     219GIStest=# CREATE EXTENSION postgis; 
    220220CREATE EXTENSION 
    221 postgres=# 
     221GIStest=# 
    222222}}} 
    223223 
    224224To add topology support, a second extension can be created on the database: 
    225225{{{ 
    226 postgres=# CREATE EXTENSION postgis_topology; 
     226GIStest=# CREATE EXTENSION postgis_topology; 
    227227CREATE EXTENSION 
    228 postgres=# 
     228GIStest=# 
    229229}}} 
    230230