Changes between Version 54 and Version 55 of GeoDjangoInstall

Timestamp:

Aug 16, 2008, 4:15:43 PM (16 years ago)

Author:

springmeyer

Comment:

Notes on creating a db for GeoDjango

GeoDjangoInstall

@@ -122 +122 @@
 
 Next, create a role and database for your application, and allow it to access PostGIS functionality.
+
+Start by switching into the `postgres user`
 {{{
 # su - postgres
+}}}
+As the `postgres` user (the user who initialized the database cluster) now do:
+{{{
 $ createuser <user>
+}}}
+If you get any error see http://www.postgresql.org/docs/8.3/interactive/tutorial-createdb.html
+{{{
 $ createdb -O <user> <db_name>
 $ createlang plpgsql <db_name>
 }}}
 Now, load the postgis sql functions and spatial_ref_table of projection information.
- * Note:PostGIS SQL files are ''ususally'' installed in the PostgreSQL share directory (`/usr/postgres/8.2/share` in the example below; use the `pg_config --sharedir` command to determine this directory on your system, which can vary widely depending on your PostgreSQL version and install method as well as how you install postgis, ie from source or with apt-get).
+Note: PostGIS SQL files are ''ususally'' installed in the PostgreSQL share directory (`/usr/postgres/8.2/share` in the example below; use the `pg_config --sharedir` command to determine this directory on your system, which can vary widely depending on your PostgreSQL version and install method as well as how you install postgis, ie from source or with apt-get).
 {{{
 $ psql -d <db_name> -f /usr/postgres/8.2/share/lwpostgis.sql # check your PostgreSQL Version, 8.x