back to - Workflow for the ChinaGIS-Projekt? main page =====DataBase? Setup ===== ====Required Downloads ==== ​PostgreSQL
​PostGis
​GEOS und PROJ Frameworks
​Gnu Make

====Additional Downloads ==== ​Udig - A simple GIS-Tool

====Procedure ====

• Gnu Make
• Frameworks
• PostgreSQL
• PostGis
• (Udig)

===PostgreSQL ===

• Download Source
• zip/tar Source

<code>

tar -xf postgresql-8.3.3.tar.bz2

</code>

• open terminal, change to source-dir of Postgres and then:

<code>

./configure --prefix=/Developer/usr/local/pgsql make sudo su make install

</code>

• initiating new datadirectory, to create new database use 'createdb'

<code>

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

</code>

• start the database-server:

<code>

/Developer/usr/local/pgsql/bin/postgres -D /Developer/usr/local/pgsql/data

</code>

or

<code>

/Developer/usr/local/pgsql/bin/pg_ctl start -w -D /Developer/usr/local/pgsql/data

</code>

• to shut the server down:

<code>

ctr c

</code>

or

<code>

/Developer/usr/local/pgsql/bin/pg_ctl stop -w -D /Developer/usr/local/pgsql/data -m i

</code>

===PostGis? ===

• Download Source
• zip/tar Source
• open terminal, change to source-dir of PostGis? and then:

<code> 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 </code>

Data-import from *.shp-File like this (full data-import script below)

<code> /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> </code>

• start Udig and enjoy!