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:


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

1 Answer 1


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

  • In truth I'm using PG-9.0
    – Laura
    Commented Jun 5, 2011 at 11:56
  • I don't think there are Windows binaries for 9.0 yet.
    – underdark
    Commented Jun 5, 2011 at 12:17
  • 1
    "ERROR: type "geometry" does not exist" sounds like you haven't installed PostGIS.
    – underdark
    Commented Jun 5, 2011 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
    Commented Jun 6, 2011 at 17:21

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.