I'm very new to pgRouting! I installed PostgreSQL 8.4, and pgrouting 1.03 on win7. I need to solve a TSP problem so I was trying to install the TSL functionality as showen at: http://www.pgrouting.org/docs/1.x/install.html but when I type psql -U postgres -f /usr/share/postlbs/routing_tsp.sql routing and psql -U postgres -f /usr/share/postlbs/routing_tsp_wrappers.sql routing I get an error, as the .sql files can't be found! How can I solve? Where can I download any maps (openstreetmap) to practice? thanks Laura

  • You should paste the error message into the body of your question. It will make it easier for others to understand your situation and answer your question. Commented Jun 10, 2011 at 19:15
  • The error was: No such file or directory!
    – Laura
    Commented Jun 11, 2011 at 9:57

2 Answers 2


This GISe Answer will help

Configuring pgRouting on Win7

Verified by Mapperz but full credit to Underdark.

  • If I understand your advice, you are suggesting me to use Ubuntu instead of win! Isn't there any other solution, I need to make my project work on both win and ubuntu!
    – Laura
    Commented Jun 10, 2011 at 17:15
  • You don't need to change to Ubuntu. The instructions are there are designed for Win7.
    – underdark
    Commented Jun 10, 2011 at 17:59
  • Yes, but there's to reference to TSP functionalities!
    – Laura
    Commented Jun 11, 2011 at 7:06
  • In forder /share/contrib of version 1.03 of pgRouting there aren't files for supporting TSP functionality (routing_tsp.sql and routing_tsp_wrapping) on the other hand these files are included in 1.0 version!
    – Laura
    Commented Jun 11, 2011 at 7:10
  • I had a lot of trouble getting pgRouting to work on Win7. It would run but had a lot of route-specific errors. Basically the built binaries for Windows are a few versions out of date. So you have to build new ones, or use an OS with the latest binaries available (eg. Linux).
    – winwaed
    Commented Jun 13, 2011 at 14:16

You stated you are trying to install this on Win7, right? It appears the paths you are using ("/usr/share/postlbs/routing_tsp_wrappers.sql") are for a linux install.

You likely need to change your paths to wherever you have downloaded the *.sql files on your computer (ie- c:\path\to\files\routing_tsp_wrappers.sql)

  • sorry! I pasted from a web site, but on my shell I wrote the correct path!
    – Laura
    Commented Jun 10, 2011 at 17:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.