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'm installing pgrouting (ver 1.03_pg-8.4.2) on my windows machine. I installed PostgreSQL and postgis without any problem, then I downloaded the binary package of pgrouting and I installed it (copy and Paste in postgresql dir). Now I'm trying to configure my first database following the instructions of http://genuchten.blogspot.com/2008/04/untitled.html but I get some errors:

1)

psql -U postgres -f ../share/contrib/lwpostgis.sql routing
ERROR: ../share/contrib/lwpostgis.sql No such file or directory

2)

psql -U postgres -f ../share/contrib/spatial_ref_sys.sql routing
ERROR: ../share/contrib/spatial_ref_sys.sql No such file or directory

3)

psql -U postgres -f ../share/contrib/routing_core.sql routing
ERROR: incompatible library: librouting.dll: verion mismatch

4)

psql -U postgres -f ../share/contrib/routing_core_wrappers.sql routing
ERROR: Type "geoms" does not exist

Can anyone help me? Thanks Laura

share|improve this question
add comment

1 Answer

You are trying to use instructions for PG 8.2 with an installation of 8.4. That's not going to work. I have instructions for 8.4 on my blog: http://underdark.wordpress.com/2011/02/07/a-beginners-guide-to-pgrouting/

In general, be careful with version numbers when dealing with PostgreSQL, PostGIS and pgRouting.

I (Mapperz) verified this morning 06/06/2011 - using Windows 7 Pro (64bit) with Postgres 8.4 and Postgis 1.5 +pgrouting .dlls

(This answer by underdark deserves bonus points!)

enter image description here

share|improve this answer
    
In truth I'm using PG-9.0 –  Laura Jun 5 '11 at 11:56
    
I don't think there are Windows binaries for 9.0 yet. –  underdark Jun 5 '11 at 12:17
    
1  
"ERROR: type "geometry" does not exist" sounds like you haven't installed PostGIS. –  underdark Jun 5 '11 at 13:27
1  
@Mapperz, wouldn't your edit be better as a comment? @sean can't add pictures with a comment - was a verification more than a comment. –  Sean Jun 6 '11 at 17:21
show 5 more comments

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.