Version 4 (modified by 14 years ago) (diff) | ,
---|
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/wiki/software:frameworks GEOS und PROJ Frameworks
http://ftp.gnu.org/gnu/make/ Gnu Make
Additional Downloads
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!