[pgrouting-dev] pgRouting 2.0 Update

pgRouting pgrouting-dev
1

Hi all,

I just pushed today's changes into my branch and only have run the build on Linux, but I in theory have it coded to install as an extension or not on pre postgresql 9.1.

None of the SQL code has been changed yet, so you should be able to do a create extension to install it, it will probably fail because of function names and stuff like that.

My next steps are:

* pull it back to mingw and see what breaks there and fix that
* install it on my postgresql 8.3/8.4 and see if it works there
* if it does, I'll create TAG or branch to keep a stable version at that state
* start looking into the issues of running it with postgis 2.x and pg9.2

Thanks,
   -Steve

2

On 3/13/2013 6:12 PM, Stephen Woodbridge wrote:

Hi all,

I just pushed today's changes into my branch and only have run the build
on Linux, but I in theory have it coded to install as an extension or
not on pre postgresql 9.1.

None of the SQL code has been changed yet, so you should be able to do a
create extension to install it, it will probably fail because of
function names and stuff like that.

My next steps are:

* pull it back to mingw and see what breaks there and fix that
* install it on my postgresql 8.3/8.4 and see if it works there
* if it does, I'll create TAG or branch to keep a stable version at that
state
* start looking into the issues of running it with postgis 2.x and pg9.2

A couple of points for anyone that wants to play with this. The first being don't expect too much this is still a work in progress and has not been tested.

git clone git@github.com:pgRouting/pgrouting.git
cd pgrouting

# this requires cmake version 2.8.10
cmake -DWITH_TSP=ON -DWITH_DD=ON .
make

# assuming everything worked with out any issues you can see
# the install targets here

ls lib
librouting_dd.so librouting_tsp.so pgrouting--1.0.7.sql.in README
librouting.so pgrouting--1.0.7.sql pgrouting.control

# make install will place *.so into pg_config --pkglibdir
# and *.{sql,control} will get placed in either:
# `pg_config --sharedir`/extension/ >= pg 9.1
# or /usr/share/pgrouting/ < pg 9.1

sudo make install

Have fun,
   -Steve

3

On 3/13/2013 6:12 PM, Stephen Woodbridge wrote:

Hi all,

I just pushed today's changes into my branch and only have run the build
on Linux, but I in theory have it coded to install as an extension or
not on pre postgresql 9.1.

None of the SQL code has been changed yet, so you should be able to do a
create extension to install it, it will probably fail because of
function names and stuff like that.

My next steps are:

* pull it back to mingw and see what breaks there and fix that
* install it on my postgresql 8.3/8.4 and see if it works there
* if it does, I'll create TAG or branch to keep a stable version at that
state
* start looking into the issues of running it with postgis 2.x and pg9.2

Corrected!

A couple of points for anyone that wants to play with this. The first being don't expect too much this is still a work in progress and has not been tested.

git clone git@github.com:pgRouting/pgrouting.git
cd pgrouting

# Doh! I forgot this most important step ##############
git checkout sew-devel-2_0

# this requires cmake version 2.8.10
cmake -DWITH_TSP=ON -DWITH_DD=ON .
make

# assuming everything worked with out any issues you can see
# the install targets here

ls lib
librouting_dd.so librouting_tsp.so pgrouting--1.0.7.sql.in README
librouting.so pgrouting--1.0.7.sql pgrouting.control

# make install will place *.so into pg_config --pkglibdir
# and *.{sql,control} will get placed in either:
# `pg_config --sharedir`/extension/ >= pg 9.1
# or /usr/share/pgrouting/ < pg 9.1

sudo make install

Have fun,
   -Steve

4

Hi all,

Some great progress tonight. I was able to do a clean clone, build, and install on a debian squeeze box with postgresql 8.4 and postgis 1.5 installed. I had to install cmake version 2.8.10.2 and gaul from source. And I was able to install a simple graph and run some simple tests on the trsp algorithm. I installed the test files in the trsp/test directory.

I can also build under mingw64, but I only have pg 9.2 and postgis 2.0 installed to test on and that will need some source changes.

So tomorrow, I need to think about what the next steps need to be and look at the sql code.

-Steve

On 3/13/2013 6:53 PM, Stephen Woodbridge wrote:

On 3/13/2013 6:12 PM, Stephen Woodbridge wrote:

Hi all,

I just pushed today's changes into my branch and only have run the build
on Linux, but I in theory have it coded to install as an extension or
not on pre postgresql 9.1.

None of the SQL code has been changed yet, so you should be able to do a
create extension to install it, it will probably fail because of
function names and stuff like that.

My next steps are:

* pull it back to mingw and see what breaks there and fix that
* install it on my postgresql 8.3/8.4 and see if it works there
* if it does, I'll create TAG or branch to keep a stable version at that
state
* start looking into the issues of running it with postgis 2.x and pg9.2

Corrected!

A couple of points for anyone that wants to play with this. The first
being don't expect too much this is still a work in progress and has not
been tested.

git clone git@github.com:pgRouting/pgrouting.git
cd pgrouting

# Doh! I forgot this most important step ##############
git checkout sew-devel-2_0

# this requires cmake version 2.8.10
cmake -DWITH_TSP=ON -DWITH_DD=ON .
make

# assuming everything worked with out any issues you can see
# the install targets here

ls lib
librouting_dd.so librouting_tsp.so pgrouting--1.0.7.sql.in README
librouting.so pgrouting--1.0.7.sql pgrouting.control

# make install will place *.so into pg_config --pkglibdir
# and *.{sql,control} will get placed in either:
# `pg_config --sharedir`/extension/ >= pg 9.1
# or /usr/share/pgrouting/ < pg 9.1

sudo make install

Have fun,
   -Steve
_______________________________________________
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

5

Hi,

Thank you for that Steve.

I have pg 9.1.8 and 2.0 installed and I am trying to build the
sew-devel-2_0 branch. When I run "cmake -DWITH_TSP=ON -DWITH_DD=ON ."
I get the following errors :

CMake Error: Target astar has dependency information when it shouldn't.
Your cache is probably stale. Please remove the entry
  astar_LIB_DEPENDS
from the cache.
CMake Error: Target dijkstra has dependency information when it shouldn't.
Your cache is probably stale. Please remove the entry
  dijkstra_LIB_DEPENDS
from the cache.
CMake Error: Target shooting_star has dependency information when it shouldn't.
Your cache is probably stale. Please remove the entry
  shooting_star_LIB_DEPENDS
from the cache.
CMake Error: Target trsp has dependency information when it shouldn't.
Your cache is probably stale. Please remove the entry
  trsp_LIB_DEPENDS
from the cache.

Looking at the CMakeCache.txt file, these lines are :

//Dependencies for target
astar_LIB_DEPENDS:STATIC=

//Dependencies for target
dijkstra_LIB_DEPENDS:STATIC=

//Dependencies for target
routing_LIB_DEPENDS:STATIC=

//Dependencies for target
shooting_star_LIB_DEPENDS:STATIC=

//Dependencies for target
trsp_LIB_DEPENDS:STATIC=

I don't know how to fix these errors. Would deleting these lines be ok ?
Thanks in advance

--
Frédéric Bonifas
+33672652807 skype:fredericbonifas

2013/3/13 Stephen Woodbridge <woodbri@swoodbridge.com>:

On 3/13/2013 6:12 PM, Stephen Woodbridge wrote:

Hi all,

I just pushed today's changes into my branch and only have run the build
on Linux, but I in theory have it coded to install as an extension or
not on pre postgresql 9.1.

None of the SQL code has been changed yet, so you should be able to do a
create extension to install it, it will probably fail because of
function names and stuff like that.

My next steps are:

* pull it back to mingw and see what breaks there and fix that
* install it on my postgresql 8.3/8.4 and see if it works there
* if it does, I'll create TAG or branch to keep a stable version at that
state
* start looking into the issues of running it with postgis 2.x and pg9.2

Corrected!

A couple of points for anyone that wants to play with this. The first being
don't expect too much this is still a work in progress and has not been
tested.

git clone git@github.com:pgRouting/pgrouting.git
cd pgrouting

# Doh! I forgot this most important step ##############
git checkout sew-devel-2_0

# this requires cmake version 2.8.10
cmake -DWITH_TSP=ON -DWITH_DD=ON .
make

# assuming everything worked with out any issues you can see
# the install targets here

ls lib
librouting_dd.so librouting_tsp.so pgrouting--1.0.7.sql.in README
librouting.so pgrouting--1.0.7.sql pgrouting.control

# make install will place *.so into pg_config --pkglibdir
# and *.{sql,control} will get placed in either:
# `pg_config --sharedir`/extension/ >= pg 9.1
# or /usr/share/pgrouting/ < pg 9.1

sudo make install

Have fun,
  -Steve
_______________________________________________
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

6

Fixed, sorry for the noise, the problem came from using cmake 2.8.7
instead of 2.8.10

Best

Frédéric Bonifas

2013/3/18 Frédéric Bonifas <fredericbonifas@gmail.com>:

Hi,

Thank you for that Steve.

I have pg 9.1.8 and 2.0 installed and I am trying to build the
sew-devel-2_0 branch. When I run "cmake -DWITH_TSP=ON -DWITH_DD=ON ."
I get the following errors :

CMake Error: Target astar has dependency information when it shouldn't.
Your cache is probably stale. Please remove the entry
  astar_LIB_DEPENDS
from the cache.
CMake Error: Target dijkstra has dependency information when it shouldn't.
Your cache is probably stale. Please remove the entry
  dijkstra_LIB_DEPENDS
from the cache.
CMake Error: Target shooting_star has dependency information when it shouldn't.
Your cache is probably stale. Please remove the entry
  shooting_star_LIB_DEPENDS
from the cache.
CMake Error: Target trsp has dependency information when it shouldn't.
Your cache is probably stale. Please remove the entry
  trsp_LIB_DEPENDS
from the cache.

Looking at the CMakeCache.txt file, these lines are :

//Dependencies for target
astar_LIB_DEPENDS:STATIC=

//Dependencies for target
dijkstra_LIB_DEPENDS:STATIC=

//Dependencies for target
routing_LIB_DEPENDS:STATIC=

//Dependencies for target
shooting_star_LIB_DEPENDS:STATIC=

//Dependencies for target
trsp_LIB_DEPENDS:STATIC=

I don't know how to fix these errors. Would deleting these lines be ok ?
Thanks in advance

--
Frédéric Bonifas
+33672652807 skype:fredericbonifas

2013/3/13 Stephen Woodbridge <woodbri@swoodbridge.com>:

On 3/13/2013 6:12 PM, Stephen Woodbridge wrote:

Hi all,

I just pushed today's changes into my branch and only have run the build
on Linux, but I in theory have it coded to install as an extension or
not on pre postgresql 9.1.

None of the SQL code has been changed yet, so you should be able to do a
create extension to install it, it will probably fail because of
function names and stuff like that.

My next steps are:

* pull it back to mingw and see what breaks there and fix that
* install it on my postgresql 8.3/8.4 and see if it works there
* if it does, I'll create TAG or branch to keep a stable version at that
state
* start looking into the issues of running it with postgis 2.x and pg9.2

Corrected!

A couple of points for anyone that wants to play with this. The first being
don't expect too much this is still a work in progress and has not been
tested.

git clone git@github.com:pgRouting/pgrouting.git
cd pgrouting

# Doh! I forgot this most important step ##############
git checkout sew-devel-2_0

# this requires cmake version 2.8.10
cmake -DWITH_TSP=ON -DWITH_DD=ON .
make

# assuming everything worked with out any issues you can see
# the install targets here

ls lib
librouting_dd.so librouting_tsp.so pgrouting--1.0.7.sql.in README
librouting.so pgrouting--1.0.7.sql pgrouting.control

# make install will place *.so into pg_config --pkglibdir
# and *.{sql,control} will get placed in either:
# `pg_config --sharedir`/extension/ >= pg 9.1
# or /usr/share/pgrouting/ < pg 9.1

sudo make install

Have fun,
  -Steve
_______________________________________________
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

--
Frédéric Bonifas
+33672652807 skype:fredericbonifas