1

I am trying to install pgRouting 2.0 on postgressql. After writing the data from the share and lib folder into C:\Program Files (x86)\PostgreSQL\9.1... I tried to create pgrouting extension on pgadmin PgSQL console by using the command "CREATE EXTENSION pgrouting". But I got the error that the library librouting.dll doesn't exist. Can anyone help me?

1

To be able to install an extension with CREATE EXTENSION pgrouting you must have all the files from pgrouting installed in the right directories. From your error message, it means that you probably have the ....\PostgreSQL...\share\extension\pgrouting.control in the right place, but you don't have the librouting.dll in the right folder:

C:\Program Files (x86)\PostgreSQL\9.1...\lib\librouting.dll

If the dll is there, it means that the user running PostgreSQL doesn't have the rights to read and execute the dll.

  • Thank you for your answer. Everything is at the right place. How to grant the user the rights to run .dll? – diesher Nov 11 '13 at 15:32
  • Did you get the right binaries (32bits or 64bits) for the right version of PostgreSQL (9.2)? If you install postgresql with the same user as pgrouting, it should be alright. Note that you need a pgrouting which is the same version as postgresql (32/64bits and 9.2). – Julien-Samuel Lacroix Nov 11 '13 at 18:27
  • I got the binaries for PostgreSQL 9.1. Is it not working with PG 9.1 or what? – diesher Nov 12 '13 at 13:10
  • It will work with 9.1 as long as both were compiled in 64bits (or both 32bits) – Julien-Samuel Lacroix Nov 12 '13 at 14:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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