Changes between Version 36 and Version 37 of InstallationGuidelines/Linux/Server/CherokeePostgreSQL

Timestamp:

03/14/12 16:22:05 (13 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/Linux/Server/CherokeePostgreSQL

@@ -629 +629 @@
 sed -i 's|deployment_settings.database.db_type = "sqlite"|deployment_settings.database.db_type = "postgres"|' ~web2py/applications/eden/models/000_config.py
 sed -i "s|deployment_settings.database.password = \"password\"|deployment_settings.database.password = \"$password\"|" ~web2py/applications/eden/models/000_config.py
-sed -i 's|deployment_settings.gis.spatialdb = False|deployment_settings.gis.spatialdb = True|' ~web2py/applications/eden/models/000_config.py
+# Spatial DAL not yet in Trunk Web2Py
+#sed -i 's|deployment_settings.gis.spatialdb = False|deployment_settings.gis.spatialdb = True|' ~web2py/applications/eden/models/000_config.py
 
 # Create the Tables & Populate with base data
@@ -637 +638 @@
 sudo -H -u web2py python web2py.py -S eden -M -R applications/eden/static/scripts/tools/noop.py
 
-# PostGIS the Sahana DB
-cat << EOF > "/tmp/geometry.sql"
-UPDATE public.gis_location SET wkt = 'POINT (' || lon || ' ' || lat || ')' WHERE gis_feature_type = 1;
-SELECT AddGeometryColumn( 'public', 'gis_location', 'the_geom', 4326, 'GEOMETRY', 2 );
-GRANT ALL ON geometry_columns TO sahana;
-UPDATE public.gis_location SET the_geom = ST_SetSRID(ST_GeomFromText(wkt), 4326);
-EOF
-su -c - postgres "psql -q -d sahana -f /tmp/geometry.sql"
-cat << EOF > "/tmp/autopopulate.sql"
-CREATE OR REPLACE FUNCTION s3_update_geometry()
-  RETURNS "trigger" AS \$$
-  DECLARE
-  BEGIN
-    if (NEW.wkt != '') then
-        NEW.the_geom = SetSRID(GeomFromText(NEW.wkt), 4326);
-        end if;
-
-    RETURN NEW;
-  END;
-\$$  LANGUAGE 'plpgsql' VOLATILE;
-ALTER FUNCTION s3_update_geometry() OWNER TO sahana;
-CREATE TRIGGER s3_locations_update
-  BEFORE INSERT
-  ON gis_location
-  FOR EACH ROW
-  EXECUTE PROCEDURE s3_update_geometry();
-
-EOF
-su -c - postgres "psql -q -d sahana -f /tmp/autopopulate.sql"
-
 # Configure for Production
 sed -i 's|deployment_settings.base.prepopulate = 1|deployment_settings.base.prepopulate = 0|' ~web2py/applications/eden/models/000_config.py