I'm unable to execute the routing_core.sql, receiving following error.
I'm using pgAdmin III, Windows 7, PostgreSQL 9.1, PostGIS 2.0.
ERROR: could not load library "C:/Program Files/PostgreSQL/9.1/lib/librouting.dll": %1 is not a valid Win32 application.
*** Error ***
ERROR: could not load library "C:/Program Files/PostgreSQL/9.1/lib/librouting.dll": %1 is not a valid Win32 application.
SQL state: 58P01
Regards,
Nas
Best Answer
Currently, pgRouting Windows binary doesn't support PostgreSQL x64(Win x86_64) version.
If you want to run pgRouting on Windows 64-bit OS, install PostgreSQL x86(Win x86_32) version.
(And PostGIS 1.5.x may be better because of assign_vertex_id - MULTILINESTRING issue.)