Changes between Version 1 and Version 2 of GeoDjangoUbuntuInstall

Timestamp:

Aug 16, 2008, 2:15:27 PM (16 years ago)

Author:

springmeyer

Comment:

Completed Draft Ubuntu Guide for installing GeoDjango

GeoDjangoUbuntuInstall

@@ -58 +58 @@
 }}}
 {{{
-sudo apt-get install postgresql postgresql-contrib postgresql-server-dev-8.3
+sudo apt-get install postgresql postgresql-contrib postgresql-server-dev-8.3 # or -8.2
 }}}
+ * Then make sure that the postgresql programs are on your path or in .bash_profile
+{{{
+Export PATH=/usr/lib/postgresql/8.3/bin/
+}}}
+ * Open up access in the pg_hba.conf file
+{{{
+sudo vim /etc/postgresql/8.2/main/pg_hba.conf
+#change ident sameuser to trust
+# comment out this line to allow, for instance, to django/psycopg2 to connect without password
+local   all         postgres                          ident sameuser
+}}}
+  * Restart the server by switching into the default user
+{{{
+sudo su - postgres
+pg_ctl -o -i -D /var/lib/postgresql/8.3/main/ restart
+}}}
+
+
+=== Step 5 ===
+Apt-get install postgis, libgdal, libgeos, and proj
+ * Note: search for the exact package names with 
+{{{
+apt-cache search GIS_LIB_NAME
+}}}
+
+{{{
+apt-get install postgresql-8.2-postgis libgeos-dev libgeos-c1 libgdal1-dev proj
+}}}
+
+=== Step 6 ===
+Create your PostGIS database
+{{{
+# Switch to the default postgres user
+sudo su - postgres
+# Create a template database with UTF encoding owned by the postgres user (or your user of choice)
+createdb -E UTF8 -O postgres -U postgres template_postgis
+# Now you can switch back to your normal user
+exit
+# 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:
+ls /usr/share/ # or /usr/local/share/
+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:
+BEGIN
+CREATE FUNCTION
+CREATE OPERATOR
+[...]
+CREATE TYPE
+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:
+ldconfig # Then restart PostgreSQL
+# Then load the geographic projections table
+psql -d template_postgis -U postgres -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql
+}}}
+
+Whoa! Hopefully that worked, and you will only have to do it once!
+
+From then on create a PostGIS database like:
+{{{
+createdb -U postgres -T template_postgis DB_NAME
+}}}
+
+=== Step 7 ===
+Return to  GeoDjangoInstall for troubleshooting and tests for GDAL and GEOS (see bottom of page)