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
Next revisionBoth sides next revision
contrib:pgrouting [2011/09/06 11:14] – [Install Required Packages] mainnerebnercontrib:pgrouting [2011/09/07 09:31] – [Add PostGIS functions] mainnerebner
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.restart+sudo /etc/init.d/postgresql-8.restart
 </code> </code>
 ==== Create routing database ==== ==== Create routing database ====
Line 66: Line 66:
          
 ==== 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