User Tools

Site Tools


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
contrib:pgrouting [2011/09/06 11:12] – [PG routing installation] mainnerebnercontrib:pgrouting [2019/01/16 10:03] (current) – external edit 127.0.0.1
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.restart+sudo /etc/init.d/postgresql-8.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/attic/contrib/pgrouting.1315300354.txt.gz · Last modified: 2019/01/16 10:03 (external edit)