back to  - [[https://it-dev.mpiwg-berlin.mpg.de/tracs/GIS/wiki/SystInst System Installation]]
== Database Setup ==
=== Required Downloads ===
[[http://www.postgresql.org/ftp/source/ PostgreSQL]][[BR]]
[[http://postgis.refractions.net/download/ PostGIS]][[BR]]
[[http://www.kyngchaos.com/wiki/software:frameworks GEOS und PROJ Frameworks]][[BR]]
[[http://ftp.gnu.org/gnu/make/ Gnu Make]]

=== Additional Downloads ===
[[http://udig.refractions.net/ Udig - A simple GIS-Tool]]

=== Procedure ===
  - Gnu Make
  - Frameworks
  - [#PostgreSQL PostgreSQL]
  - [#PostGIS PostGIS]
  - (Udig)

==== PostgreSQL ====
  * Download Source
  * zip/tar Source
{{{
  tar -xf postgresql-8.3.3.tar.bz2
}}}
  * open terminal, change to source-dir of Postgres and then:
{{{
  ./configure --prefix=/Developer/usr/local/pgsql 
  make
  sudo su
  make install
}}}
  * initiating new datadirectory, to create new database use 'createdb'
{{{
  mkdir /Developer/usr/local/pgsql/data
  chown <username> /Developer/usr/local/pgsql/data
  su - <username> 
 /Developer/usr/local/pgsql/bin/initdb -D /Developer/usr/local/pgsql/data
}}}
  * start the database-server:
{{{
  /Developer/usr/local/pgsql/bin/postgres -D /Developer/usr/local/pgsql/data  
}}}
 or 
{{{
  /Developer/usr/local/pgsql/bin/pg_ctl start -w -D /Developer/usr/local/pgsql/data
}}}
  * to shut the server down:
{{{
  ctr c 
}}}
 or 
{{{
  /Developer/usr/local/pgsql/bin/pg_ctl stop -w -D /Developer/usr/local/pgsql/data -m i
}}}

==== PostGIS ====
  * Download Source
  * zip/tar Source
  * open terminal, change to source-dir of PostGIS and then:
{{{
PATH=/Developer/usr/local/pgsql/bin:/bin:/usr/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
export PATH
./configure --prefix=/Developer/usr/local/pgsql
make
/Developer/usr/local/pgsql/bin/createdb <databasename> --encoding "UTF-8"
/Developer/usr/local/pgsql/bin/createlang plpgsql <databasename>
/Developer/usr/local/pgsql/bin/psql -f /Developer/usr/local/pgsql/share/lwpostgis.sql <databasename>
/Developer/usr/local/pgsql/bin/psql -f /Developer/usr/local/pgsql/share/lwpostgis_upgrade.sql <databasename>
/Developer/usr/local/pgsql/bin/psql -f /Developer/usr/local/pgsql/share/spatial_ref_sys.sql <databasename>
/Developer/usr/local/pgsql/bin/postgres -D /Developer/usr/local/pgsql/data
}}}
 Data-import from *.shp-File like this (full data-import script below)
{{{
/Developer/usr/local/pgsql/bin/shp2pgsql -s "2333" -S -W "UTF-8" /Developer/usr/local/pgsql/data/v4_1820_lks_pgn_utf/v4_1820_lks_pgn_utf.shp public.v4_1820_lks_pgn_utf <databasename> | /Developer/usr/local/pgsql/bin/psql -d <databasename>
}}}
  * start Udig and enjoy!