contrib:pgrouting
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
contrib:pgrouting [2011/09/06 11:07] – [Install packages] mainnerebner | contrib:pgrouting [2011/09/09 17:26] – [Setup PostgreSQL] mainnerebner | ||
---|---|---|---|
Line 4: | Line 4: | ||
http:// | http:// | ||
- | Note: | + | Environment: |
- | Installation on Ubuntu | + | < |
- | Install required packages | + | $ lsb_release -a |
- | + | No LSB modules are available. | |
- | ===== Install | + | Distributor ID: Ubuntu |
+ | Description: | ||
+ | Release: 10.04 | ||
+ | Codename: | ||
+ | </ | ||
+ | ===== Install | ||
< | < | ||
sudo apt-get install build-essential git-core cmake | sudo apt-get install build-essential git-core cmake | ||
- | sudo apt-get install postgresql-8.4-postgis postgresql-server-dev-8.4 | + | sudo apt-get install |
</ | </ | ||
Line 28: | Line 33: | ||
**For TSP** | **For TSP** | ||
< | < | ||
- | wget http:// | + | wget http:// |
tar -xzf gaul-devel-0.1850-0.tar.gz | tar -xzf gaul-devel-0.1850-0.tar.gz | ||
cd gaul-devel-0.1850-0/ | cd gaul-devel-0.1850-0/ | ||
Line 50: | Line 55: | ||
Set local database connections to “trust” in “pg_hba.conf” to be able to work with PostgreSQL as user “postgres”. Then restart PostgreSQL. | Set local database connections to “trust” in “pg_hba.conf” to be able to work with PostgreSQL as user “postgres”. Then restart PostgreSQL. | ||
< | < | ||
- | sudo gedit / | + | sudo gedit / |
- | sudo / | + | sudo / |
+ | # TYPE DATABASE | ||
+ | local all | ||
</ | </ | ||
==== Create routing database ==== | ==== Create routing database ==== | ||
Line 60: | Line 67: | ||
</ | </ | ||
| | ||
- | ==== Add PostGIS functions****Bold Text ==== | + | ==== Add PostGIS functions ==== |
+ | 8.3: | ||
< | < | ||
psql -U postgres -f / | psql -U postgres -f / | ||
psql -U postgres -f / | psql -U postgres -f / | ||
+ | </ | ||
+ | 8.4: | ||
+ | < | ||
+ | psql -U postgres -f / | ||
+ | psql -U postgres -f / | ||
</ | </ | ||
| | ||
- | **Add pgRouting functions** | + | ==== Add pgRouting functions |
< | < | ||
psql -U postgres -f / | psql -U postgres -f / |
/data/www/wiki.inf.unibz.it/data/pages/contrib/pgrouting.txt · Last modified: 2019/01/16 10:03 by 127.0.0.1