[GIS] Installing PgRouting

pgrouting

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?

Best Answer

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.

Related Question