PgRoutingInstallation

[alky]

I have installed pgrouting in windows and its working fine,but while installing in FedoroCore?,i m finding some problemin in generating library files [root@localhost pgrouting]# cmake -DWITH_TSP=ON -DWITH_DD=ON . Boost headers were found here: /usr/include Output directory for libraries is set to sh: pg_config: command not found Installation directory for libraries is set to sh: pg_config: command not found and for SQL files is set to /usr/share/postlbs Installation directory for libraries is set to sh: pg_config: command not found -- Configuring done -- Generating done -- Build files have been written to: /opt/pickndrop/pgrouting

[root@localhost pgrouting]# make

[ 16%] Built target routing_tsp Scanning dependencies of target routing_dd [ 25%] Building C object extra/driving_distance/src/CMakeFiles/routing_dd.dir/alpha.o [ 33%] Building C object extra/driving_distance/src/CMakeFiles/routing_dd.dir/drivedist.o /opt/pickndrop/pgrouting/extra/driving_distance/src/drivedist.c: In function ‘fetch_edge_columns’: /opt/pickndrop/pgrouting/extra/driving_distance/src/drivedist.c:129: error: ‘INT4OID’ undeclared (first use in this function) /opt/pickndrop/pgrouting/extra/driving_distance/src/drivedist.c:129: error: (Each undeclared identifier is reported only once /opt/pickndrop/pgrouting/extra/driving_distance/src/drivedist.c:129: error: for each function it appears in.) /opt/pickndrop/pgrouting/extra/driving_distance/src/drivedist.c:131: error: ‘FLOAT8OID’ undeclared (first use in this function) make[2]: *** [extra/driving_distance/src/CMakeFiles/routing_dd.dir/drivedist.o] Error 1 make[1]: *** [extra/driving_distance/src/CMakeFiles/routing_dd.dir/all] Error 2 make: *** [all] Error 2

how should i rectify this problem.... Pg routing for windows has library files in downloads,do we have similar library files for Linux in the downloads

waiting for reply thanks in advance

[anton]

Make sure you installed postgresql-devel package. You might also look here http://pgrouting.postlbs.org/discussion/topic/241.

[alky]

[root@localhost pgrouting]# make

Scanning dependencies of target routing_tsp [ 8%] Building CXX object extra/tsp/src/CMakeFiles/routing_tsp.dir/tsp_solver.o Linking CXX shared library ../../../lib/librouting_tsp.so [ 16%] Built target routing_tsp [ 25%] Building C object extra/driving_distance/src/CMakeFiles/routing_dd.dir/drivedist.o /opt/pickndrop/pgrouting/extra/driving_distance/src/drivedist.c: In function ‘fetch_edge_columns’: /opt/pickndrop/pgrouting/extra/driving_distance/src/drivedist.c:129: error: ‘INT4OID’ undeclared (first use in this function) /opt/pickndrop/pgrouting/extra/driving_distance/src/drivedist.c:129: error: (Each undeclared identifier is reported only once /opt/pickndrop/pgrouting/extra/driving_distance/src/drivedist.c:129: error: for each function it appears in.) /opt/pickndrop/pgrouting/extra/driving_distance/src/drivedist.c:131: error: ‘FLOAT8OID’ undeclared (first use in this function) make[2]: *** [extra/driving_distance/src/CMakeFiles/routing_dd.dir/drivedist.o] Error 1 make[1]: *** [extra/driving_distance/src/CMakeFiles/routing_dd.dir/all] Error 2 make: *** [all] Error 2

i Still got this Error,how should i fix this.Please guys help me..

[anton]

It means that PostgreSQL header files are still not reachable.

[thge]

I have the same problem. It is a postgreSQL 8.4 issue. The following discussion led me on the right way:

 http://archive.netbsd.se/?ml=slony1-hackers&a=2009-02&t=9972566

First of all, my error looked like this:

[ 16%] Building C object core/src/CMakeFiles/routing.dir/dijkstra.o
/home/thomasg/pgrouting/core/src/dijkstra.c: In function âfetch_edge_columnsâ:
/home/thomasg/pgrouting/core/src/dijkstra.c:98: error: âINT4OIDâ undeclared (first use in this function)
/home/thomasg/pgrouting/core/src/dijkstra.c:98: error: (Each undeclared identifier is reported only once
/home/thomasg/pgrouting/core/src/dijkstra.c:98: error: for each function it appears in.)
/home/thomasg/pgrouting/core/src/dijkstra.c:100: error: âFLOAT8OIDâ undeclared (first use in this function)
make[2]: *** [core/src/CMakeFiles/routing.dir/dijkstra.o] Error 1
make[1]: *** [core/src/CMakeFiles/routing.dir/all] Error 2
make: *** [all] Error 2

(I only compile the core)

So my solution: adding the line

#include "catalog/pg_type.h"

into these files (after including the "executor/spi.h"):

/core/src/dijkstra.c
/core/src/astar.c
/core/src/shooting_star.c

You should consider this for the next version and make a bugfix that pgRouting is compatible with postgreSQL 8.4

thomas

[anton]

Hi Thomas,

Thank you! I will fix the code.