Changes between Version 27 and Version 28 of InstallationGuidelines/PostgreSQL

Timestamp:

10/24/10 17:30:40 (14 years ago)

Author:

Fran Boon

Comment:

Spatialising the Sahana DB

InstallationGuidelines/PostgreSQL

@@ -130 +130 @@
 }}}
 
+== Add Geometry column to gis_location ==
+If using PostGIS, then once the tables have been created:
+{{{
+su postgres
+psql
+\d sahana
+SELECT AddGeometryColumn( 'public', 'gis_location', 'the_geom', 4326, 'POINT', 2 );
+exit
+vim models/0000_config.py
+deployment_settings.gis.spatialdb = True
+}}}
 == Backups ==
 {{{