Guest User

Untitled

a guest
Feb 22nd, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. sudo apt-get install postgresql-9.1 postgresql-9.1-contrib postgresql-9.1-postgis and created databse "mydb". Then extended the mydb using
  2.  
  3. psql -h localhost -d mydb -U abc -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
  4.  
  5. psql -h localhost -d mydb -U abc -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql
  6.  
  7. sudo dpkg -i Downloads/postgresql-9.1-pgrouting_2.1.0-ppa1~precise1_i386.deb
  8.  
  9. psql -h localhost -d mydb -U abc -f /usr/share/postgresql/9.1/extension/pgrouting--2.1.0.sql
  10.  
  11. SELECT * FROM pgr_dijkstra('
  12. SELECT id,
  13. source,
  14. target,
  15. cost,
  16. reverse_cost
  17. FROM ways',
  18. 15,
  19. 16,
  20. directed := true)
Add Comment
Please, Sign In to add comment