Changes between Version 27 and Version 28 of InstallationGuidelines/PostgreSQL


Ignore:
Timestamp:
10/24/10 17:30:40 (11 years ago)
Author:
Fran Boon
Comment:

Spatialising the Sahana DB

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/PostgreSQL

    v27 v28  
    130130}}}
    131131
     132== Add Geometry column to gis_location ==
     133If using PostGIS, then once the tables have been created:
     134{{{
     135su postgres
     136psql
     137\d sahana
     138SELECT AddGeometryColumn( 'public', 'gis_location', 'the_geom', 4326, 'POINT', 2 );
     139exit
     140vim models/0000_config.py
     141deployment_settings.gis.spatialdb = True
     142}}}
    132143== Backups ==
    133144{{{