Changes between Version 1 and Version 2 of DatabaseSetup


Ignore:
Timestamp:
Feb 3, 2010, 12:35:28 PM (14 years ago)
Author:
fknauft
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseSetup

    v1 v2  
    1 back to  - [[...|Workflow for the ChinaGIS-Projekt]] main page
    2 =====DataBase Setup =====
    3 ====Required Downloads ====
     1back to  - [[https://it-dev.mpiwg-berlin.mpg.de/tracs/GIS/wiki/SystInst System Installation]]
     2== Database Setup ==
     3=== Required Downloads ===
    44[[http://www.postgresql.org/ftp/source/|PostgreSQL]]\\
    55[[http://postgis.refractions.net/download/|PostGis]]\\
    … …  
    77[[http://ftp.gnu.org/gnu/make/|Gnu Make]]
    88
    9 ====Additional Downloads ====
     9=== Additional Downloads ===
    1010[[http://example.com|Udig - A simple GIS-Tool]]
    1111
    12 ====Procedure ====
     12=== Procedure ===
    1313  - Gnu Make
    1414  - Frameworks
    … …  
    1717  - (Udig)
    1818
    19 ===PostgreSQL ===
     19==== PostgreSQL ====
    2020  * Download Source
    2121  * zip/tar Source
    22 <code>
     22{{{
    2323  tar -xf postgresql-8.3.3.tar.bz2
    24 </code>
     24}}}
    2525  * open terminal, change to source-dir of Postgres and then:
    26 <code>
     26{{{
    2727  ./configure --prefix=/Developer/usr/local/pgsql
    2828  make
    2929  sudo su
    3030  make install
    31 </code>
     31}}}
    3232  * initiating new datadirectory, to create new database use 'createdb'
    33 <code>
     33{{{
    3434  mkdir /Developer/usr/local/pgsql/data
    3535  chown <username> /Developer/usr/local/pgsql/data
    3636  su - <username>
    3737 /Developer/usr/local/pgsql/bin/initdb -D /Developer/usr/local/pgsql/data
    38 </code>
     38}}}
    3939  * start the database-server:
    40 <code>
     40{{{
    4141  /Developer/usr/local/pgsql/bin/postgres -D /Developer/usr/local/pgsql/data 
    42 </code>
     42}}}
    4343 or
    44 <code>
     44{{{
    4545  /Developer/usr/local/pgsql/bin/pg_ctl start -w -D /Developer/usr/local/pgsql/data
    46 </code>
     46}}}
    4747  * to shut the server down:
    48 <code>
     48{{{
    4949  ctr c
    50 </code>
     50}}}
    5151 or
    52 <code>
     52{{{
    5353  /Developer/usr/local/pgsql/bin/pg_ctl stop -w -D /Developer/usr/local/pgsql/data -m i
    54 </code> 
     54}}}
    5555
    56 ===PostGis ===
     56==== PostGIS ====
    5757  * Download Source
    5858  * zip/tar Source
    5959  * open terminal, change to source-dir of PostGis and then:
    60 <code>
     60{{{
    6161PATH=/Developer/usr/local/pgsql/bin:/bin:/usr/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
    6262export PATH
    … …  
    6969/Developer/usr/local/pgsql/bin/psql -f /Developer/usr/local/pgsql/share/spatial_ref_sys.sql <databasename>
    7070/Developer/usr/local/pgsql/bin/postgres -D /Developer/usr/local/pgsql/data
    71 </code>
     71}}}
    7272 Data-import from *.shp-File like this (full data-import script below)
    73 <code>
     73{{{
    7474/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>
    75 </code>
     75}}}
    7676  * start Udig and enjoy!