Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

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?

share|improve this answer
    
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 '13 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 '13 at 6:18
1  
Did you connect to routing_template using Add PostGIS Layer - New? –  underdark Apr 2 '13 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 '13 at 2:56
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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