Changes between Version 3 and Version 4 of GeoDjangoInstall

Timestamp:

Sep 16, 2007, 5:30:11 PM (17 years ago)

Author:

jbronn

Comment:

simplified database creation instructions

GeoDjangoInstall

@@ -62 +62 @@
 }}}
 
- * Next, create a role and database for your application, and allow it to access PostGIS functionality:
+ * Next, create a role and database for your application, and allow it to access PostGIS functionality.  PostGIS SQL files are installed in the PostgreSQL share directory (`/usr/postgres/8.2/share` in the example below -- use `pg_config --sharedir` to determine this directory on your system).
 {{{
 # su - postgres
-$ psql
-postgres=# CREATE ROLE <user> LOGIN;
-postgres=# \q
+$ createuser <user>
 $ createdb -O <user> <db_name>
 $ createlang plpgsql <db_name>
-$ psql -d <db_name> -f /usr/local/share/lwpostgis.sql
-$ psql -d <db_name> -f /usr/local/share/spatial_ref_sys.sql
+$ psql -d <db_name> -f /usr/postgres/8.2/share/lwpostgis.sql
+$ psql -d <db_name> -f /usr/postgres/8.2/share/spatial_ref_sys.sql
 $ psql <db_name>
 <db_name>=# GRANT SELECT, UPDATE, INSERT, DELETE ON geometry_columns TO <user>;
@@ -80 +78 @@
 
 === GDAL ===
- * ''Highly Recommended'': Some features (e.g. a large number of {{{SpatialRefSys}}} model routines) require GDAL, but it is not necessary for core functionality (e.g. spatial queries).  
- * GDAL/OGR includes useful for coordinate transformations and reading/writing ''both'' vector (e.g. SHP) and raster (e.g. GeoTIFF) geographic data.
+ * ''Highly Recommended'': Some features (''e.g.'', a large number of {{{SpatialRefSys}}} model routines) require GDAL, but it is not necessary for core functionality like spatial queries.  
+ * GDAL/OGR includes useful for coordinate transformations and reading/writing ''both'' vector (''e.g.'', SHP) and raster (''e.g.'', GeoTIFF) geographic data.
    * For example, the following command will convert your SHP file into [http://en.wikipedia.org/wiki/WGS84 WGS84] (standard lat/lon).  Then you can import directly into your database using {{{shp2pgsql}}} (utility from PostGIS):
 {{{