[GIS] Issues with installing pgrouting in mac

macpgrouting

I installed both postgresql and postgis using brew in mac. How can I now install pgrouting. I couldn't install it using brew. Any suggestions?

Best Answer

You can download Mac OS X installers from this website: http://www.kyngchaos.com/software/postgres

I don't know this is compatible with what you installed using brew, but the PostgreSQL/PostGIS binaries you can get from that website should work well, too.

Related Solutions

[GIS] Installing PgRouting

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.

[GIS] How to install pgRouting on PostgreSQL 9.2 located at /opt/PostgreSQL/9.2/ on Ubuntu Server 12.10

You can't install pgrouting for PostgreSQL 9.1 into PostgreSQL 9.2. Even if you could install the package without downloading all of 9.1, it wouldn't work, it'd just be unavailable - totally invisible to Pg 9.2.

If PgRouting is not included in EDB's StackBuilder you will need to build it from source code according to the instructions on the PgRouting website. See the source code readme for guidance on this process. When compiling pgrouting, you may need to add the appropriate pg_config to the PATH, e.g:

PATH=/opt/PostgreSQL/9.2/bin:$PATH

Alternately, you could use the PGDG packages of PostgreSQL for Ubuntu instead of the EDB installer. That will get you PostGIS and PgRouting for PostgreSQL 9.2 (or 9.3) via apt-get. See http://wiki.postgresql.org/wiki/Apt . This will do a new PostgreSQL installation - it won't use your existing database in /opt, so you will need to do a pg_dump and then restore the DB if there's any data you want to keep. It won't delete or replace the DB in /opt, it'll just create a new PostgreSQL on a different port, probably 5433.

Best Answer

Related Solutions

[GIS] Installing PgRouting

[GIS] How to install pgRouting on PostgreSQL 9.2 located at /opt/PostgreSQL/9.2/ on Ubuntu Server 12.10

Related Question