Changes between Version 55 and Version 56 of GeoDjangoInstall

Timestamp:

Aug 16, 2008, 4:31:56 PM (16 years ago)

Author:

springmeyer

Comment:

More PostgreSQL/PostGIS notes

GeoDjangoInstall

@@ -123 +123 @@
 Next, create a role and database for your application, and allow it to access PostGIS functionality.
 
-Start by switching into the `postgres user`
+Start by switching into the `postgres user`(see below about db initialization if you don't have a postgres user)
 {{{
 # su - postgres
@@ -131 +131 @@
 $ createuser <user>
 }}}
-If you get any error see http://www.postgresql.org/docs/8.3/interactive/tutorial-createdb.html
+ * Note: if you have not initialized the postgres db cluster (if you used apt-get to install postgresql this was already done) do this:
+ {{{
+sudo adduser postgres
+# run through interactive prompt
+sudo su - postgres
+mkdir /path/to/postgres/data
+chmod -R 700 /path/to/postgres/data
+initdb -D /path/to/postgres/data
+pg_ctl start -D /path/to/postgres/data
+}}}
+If you get any errors see http://www.postgresql.org/docs/8.3/interactive/tutorial-createdb.html
+
+Now, create the database with your chosen user:
 {{{
 $ 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.
+
+In addition, depending on your install method for postgis the sql files may be in another location like `/usr/share'.
+
 {{{
 $ psql -d <db_name> -f /usr/postgres/8.2/share/lwpostgis.sql # check your PostgreSQL Version, 8.x