Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 but I get some errors:


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


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


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


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

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:

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
"ERROR: type "geometry" does not exist" sounds like you haven't installed PostGIS. – underdark Jun 5 '11 at 13:27
@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

Your Answer


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.