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

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
contrib:pgrouting [2011/09/06 11:08] – [Add PostGIS functions****Bold Text] mainnerebnercontrib:pgrouting [2012/01/06 15:06] – [Setup PostgreSQL] mainnerebner
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 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 61: Line 73:
          
 ==== Add PostGIS functions ====  ==== 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>
          
/data/www/wiki.inf.unibz.it/data/pages/contrib/pgrouting.txt · Last modified: 2019/01/16 10:03 by 127.0.0.1