[pgrouting-users] routing_dd.sql error, inserting on OS X/Homebrew

Last night I happily discovered pgRouting had been added to Mac OS X Homebrew https://github.com/mxcl/homebrew/pull/8017 and https://github.com/charlax/homebrew.

I was trying to add Driving Distance functions to the database I created from a PostGIS template (after I added the routing_core, wrappers and topology) as per this post http://underdark.wordpress.com/2011/05/13/catchment-areas-with-pgrouting-driving_distance/ but I got an error when inserting routing_dd.sql:

psql -d template_routing -f /usr/local/Cellar/pgrouting/1.05/share/postlbs/routing_dd.sql
psql:/usr/local/Cellar/pgrouting/1.05/share/postlbs/routing_dd.sql:28: ERROR: could not access file “$libdir/librouting_dd”: No such file or directory
psql:/usr/local/Cellar/pgrouting/1.05/share/postlbs/routing_dd.sql:38: ERROR: could not access file “$libdir/librouting_dd”: No such file or directory

Does anyone have some insights on what might be going on here? Thank you, Joe.

On 11/12/2011 4:04 PM, Joe Larson wrote:

Last night I happily discovered pgRouting had been added to Mac OS X
Homebrew https://github.com/mxcl/homebrew/pull/8017 and
https://github.com/charlax/homebrew.

I was trying to add Driving Distance functions to the database I created
from a PostGIS template (after I added the routing_core, wrappers and
topology) as per this post
http://underdark.wordpress.com/2011/05/13/catchment-areas-with-pgrouting-driving_distance/
but I got an error when inserting routing_dd.sql:

psql -d template_routing -f
/usr/local/Cellar/pgrouting/1.05/share/postlbs/routing_dd.sql
psql:/usr/local/Cellar/pgrouting/1.05/share/postlbs/routing_dd.sql:28:
ERROR: could not access file "$libdir/librouting_dd": No such file or
directory
psql:/usr/local/Cellar/pgrouting/1.05/share/postlbs/routing_dd.sql:38:
ERROR: could not access file "$libdir/librouting_dd": No such file or
directory

Does anyone have some insights on what might be going on here? Thank
you, Joe.

Joe,

I think the librouting_dd.so gets built separate from the core pgrouting.

cmake -DWITH_DD=ON -DWITH_TSP=ON .
make
make install

If the person that built for OS X did not build with the -DWITH_DD=ON option then there will not be a library for the sql to link with.

-Steve