Changes between Version 2 and Version 3 of GeoDjangoUbuntuInstall

Timestamp:

Aug 16, 2008, 2:26:48 PM (16 years ago)

Author:

springmeyer

Comment:

Cleanup up PostGIS example for GeoDjango Ubuntu Install Guide

GeoDjangoUbuntuInstall

@@ -67 +67 @@
 {{{
 sudo vim /etc/postgresql/8.2/main/pg_hba.conf
-#change ident sameuser to trust
+# change ident sameuser to trust - WARNING SECURITY RISK
 # comment out this line to allow, for instance, to django/psycopg2 to connect without password
 local   all         postgres                          ident sameuser
@@ -90 +90 @@
 
 === Step 6 ===
-Create your PostGIS database
+Create your PostGIS `template_postgis` database
 {{{
 # Switch to the default postgres user
@@ -100 +100 @@
 # Load the required procedural language for postgis
 createlang plpgsql -d template_postgis -U postgres
-# Load optional languages
-# Load postgis functions and spatial reference info
-# which likely was installed in the postgres share directory
-pg_config --sharedir
-/usr/local/pgsql/share
-# Also look for lwpostgis.sql and spatial_ref_sys.sql in:
+}}}
+
+Now you are ready to actually load the postgis functions and tables as sql inserts
+ * Note: the two postgis sql files (lwpostgis.sql and spatial_ref_sys.sql) were likely installed in the postgres share directory
+{{{
+pg_config --sharedir # will give you that dir
+# Also look in:
 ls /usr/share/ # or /usr/local/share/
+}}}
+Try:
+{{{
 psql -d template_postgis -U postgres -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql
 # Note: ignore any NOTICES, like 'psql:/usr/share/lwpostgis.sql:44: NOTICE:  type "histogram2d" is not yet defined'
-# You should see output like:
+}}}
+ * You should see output like:
+{{{
 BEGIN
 CREATE FUNCTION
@@ -117 +123 @@
 CREATE AGGREGATE
 COMMIT
-# If you get an error about not being able to find  `geos` add:
-/usr/local/lib to /etc/ld.so.conf
-# And run:
+}}}
+ * If you get an error about not being able to find  `geos` add /usr/local/lib to /etc/ld.so.conf and run:
+{{{
 ldconfig # Then restart PostgreSQL
-# Then load the geographic projections table
+}}}
+Then load the geographic projections table:
+{{{
 psql -d template_postgis -U postgres -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql
 }}}