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:12] – [PG routing installation] mainnerebnercontrib:pgrouting [2012/01/06 15:06] – [Setup PostgreSQL] mainnerebner
Line 6: Line 6:
 Environment: Environment:
 <code> <code>
-.....@bz10m:/data$ lsb_release -a +$ lsb_release -a 
 No LSB modules are available. No LSB modules are available.
 Distributor ID: Ubuntu Distributor ID: Ubuntu
Line 13: Line 13:
 Codename: lucid Codename: lucid
 </code> </code>
- +===== Install Required Packages =====
-Note: +
-Install required packages +
- +
-===== Install 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 37: 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 59: 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 70: 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