I followed this website:A Beginner’s Guide to pgRouting and now facing some problems.

I finished steps before "Creating a routable road network", and open QGIS 1.8, click the PostGIS Manager plugin, here's the figure:enter image description here, the first question is that how to enable PostGIS support?

And if I click the Data button trying to load data from shapefile, here's the figure:enter image description here

And when I try either way:back to QGIS menu->click the Database->shp to postgis->key in my password->click connect, then it shows:enter image description here

How to solve these problem and correctly use pgrouting?

ps.I work under windows7 64-bit, and have QGIS1.8, postgres8.4, pgadmin3, postgis2.0 installed.

1 Answer 1


You might have installed PostGIS but everything seems like the database you are using for the pgrouting exercise is not PostGIS-enabled. After installing PostGIS on Windows, there should be a postgis_template database. Did you create your pgRouting database using the postgis_template?

  • I create an new database based on template_postgis_20,and load 3 sql files again, then I open QGIS, click PostGIS Manager, how can I set link to the new database instead of directly linking to the older one:template_postgis_20?
    – Heinz
    Apr 1, 2013 at 13:55
  • After read your comment I open pgadmin3 and create an new database based on template_postgis_20, named routing_template, but when I go to QGIS, I still got the same problem like the first photo in my questions.
    – Heinz
    Apr 2, 2013 at 6:18
  • 1
    Did you connect to routing_template using Add PostGIS Layer - New?
    – underdark
    Apr 2, 2013 at 10:35
  • I Add PostGIS Layer, and it works(I add a polygon file), but when I try either way:use PostGIS Manager, I still got the second photo in my question. When I want to add a polyline file in pgadmin as you described in your pgrouting tutoral, I got this message:Importing with configuration: tochienrouting, public, geom, C:\Users\HeinzChen\Desktop\new _folder\ToChienRouting, mode=c, dump=1, simple=0, geography=0, index=1, shape=1, srid=0 Shapefile type: Arc PostGIS type: MULTILINESTRING[2] Error reading shape object 15 Shapefile import failed.
    – Heinz
    Apr 3, 2013 at 2:56

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.