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?
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.