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 14:46] – [Add PostGIS functions] mainnerebnercontrib:pgrouting [2019/01/16 10:03] (current) – external edit 127.0.0.1
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.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 73: Line 80:
 8.4: 8.4:
 <code> <code>
-psql -U postgres -f /usr/share/postgresql-8.4-postgis/postgis.sql routing+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 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