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
​http://postgis.refractions.net/download/ PostGIS
​http://www.kyngchaos.com/software:frameworks GEOS und PROJ Frameworks
libxml2 Frameworks
​http://ftp.gnu.org/gnu/make/ Gnu Make

Additional Downloads

​http://udig.refractions.net/ Udig - A simple GIS-Tool

Procedure

• Gnu Make
• Frameworks
• PostgreSQL
• 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!