Engineering-Tech Wiki

User Tools

Site Tools

You are here: start » contrib » pgrouting
Trace:
contrib:pgrouting

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
contrib:pgrouting [2011/09/06 11:06] – created mainnerebnercontrib:pgrouting [2019/01/16 10:03] (current) – external edit 127.0.0.1
Line 4: Line 4:
 http://www.pgrouting.org/docs/1.x/install_ubuntu.html) http://www.pgrouting.org/docs/1.x/install_ubuntu.html)
  
-Note: +Environment: 
-Installation on Ubuntu 9.04 (with PostgreSQL 8.3) with TSP and Driving Distance (Extras). (After had some troubles to install pgRouting on Ubuntu 8.10, it works again with Ubuntu 9.04.) +<code> 
-Install required packages +$ lsb_release -a  
- +No LSB modules are available. 
-===== Install packages =====+Distributor ID: Ubuntu 
 +Description: Ubuntu 10.04.3 LTS 
 +Release: 10.04 
 +Codename: lucid 
 +</code> 
 +===== Install Required Packages =====
 <code> <code>
 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 postgresql postgresql-8.4-postgis postgresql-server-dev-8.4
 </code> </code>
  
Line 19: Line 24:
 </code> </code>
  
-    For Driving Distance+**For Driving Distance**
 <code> <code>
 sudo apt-get install libcgal* sudo apt-get install libcgal*
Line 28: Line 33:
 **For TSP** **For TSP**
 <code> <code>
-wget http://downloads.sourceforge.net/gaul/gaul-devel-0.1849-0.tar.gz+wget http://downloads.sourceforge.net/gaul/gaul-devel-0.1850-0.tar.gz
 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.
 <code> <code>
-sudo gedit /etc/postgresql/8.3/main/pg_hba.conf +sudo gedit /etc/postgresql/8.4/main/pg_hba.conf 
-sudo /etc/init.d/postgresql-8.3 restart+sudo /etc/init.d/postgresql-8.4 restart 
 +# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD 
 +local    all     all      trust 
 +</code> 
 + 
 +==== Start postgresql daemon ==== 
 +<code bash> 
 +sudo /etc/init.d/postgresql-8.4 start
 </code> </code>
 ==== Create routing database ==== ==== Create routing database ====
Line 60: Line 72:
 </code> </code>
          
-==== Add PostGIS functions****Bold Text ==== +==== Add PostGIS functions ====  
 +8.3:
 <code> <code>
 psql -U postgres -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql routing psql -U postgres -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql routing
 psql -U postgres -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql routing psql -U postgres -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql routing
 +</code>
 +8.4:
 +<code>
 +psql -U postgres -f /usr/share/postgresql/8.4/contrib/postgis.sql routing
 +psql -U postgres -f /usr/share/postgresql/8.4/contrib/spatial_ref_sys.sql routing
 </code> </code>
          
-**Add pgRouting functions**+==== Add pgRouting functions ====
 <code> <code>
 psql -U postgres -f /usr/share/postlbs/routing_core.sql routing psql -U postgres -f /usr/share/postlbs/routing_core.sql routing
/data/www/wiki.inf.unibz.it/data/attic/contrib/pgrouting.1315300004.txt.gz · Last modified: 2019/01/16 10:03 (external edit)