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

Timestamp:

03/14/12 16:20:08 (14 years ago)

Author:

Fran Boon

Comment:

PostGIS is done differently with Spatial DAL

InstallationGuidelines/Linux/Server/CherokeePostgreSQL

@@ -466 +466 @@
 su -c - postgres "psql -q -d sahana -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql"
 su -c - postgres "psql -q -d sahana -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql"
+su -c - postgres "psql -q -d sahana -c 'grant all on geometry_columns to sahana;'"
+su -c - postgres "psql -q -d sahana -c 'grant all on spatial_ref_sys to sahana;'"
 cd ~web2py
 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"
 cd ~web2py/applications/eden
 sed -i 's/deployment_settings.base.migrate = True/deployment_settings.base.migrate = False/g' models/000_config.py