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:14] – [Install Required Packages] mainnerebnercontrib:pgrouting [2012/01/06 15:06] – [Setup PostgreSQL] mainnerebner
Line 16: Line 16:
 <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 55: 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 66: 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