[pgrouting-users] Migration Guide from v1 to v2

Hi,

I have an application that uses pgRouting v1. I was wondering if it is possible to easily migrate from version 1 to version 2 of pgRouting. I noticed that the pgRouting v2 announcement stated that v2 is not baskwards compatible, is there any guide / list of steps to get it working using v2.

I already have postgres 9.3, postgis2.1 and pgrouting 2.0 installed (the ones available in the Ubuntu 14.04 repositories).

I'm reading the documentation for 2.0 and will read the workshop, but it does not look like there is a migration chapter.

Wrapping up, is there (or will be) any migration guide?

Regards.
Javier Monge.

On Mon, Nov 25, 2013 at 7:47 PM, Javier Mr <javiersdevmail@ymail.com> wrote:

Hi,

I have an application that uses pgRouting v1. I was wondering if it is
possible to easily migrate from version 1 to version 2 of pgRouting. I
noticed that the pgRouting v2 announcement stated that v2 is not baskwards
compatible, is there any guide / list of steps to get it working using v2.

No there is no migration guide.
Anyone, who wants to contribute one is welcome. :wink:

I already have postgres 9.3, postgis2.1 and pgrouting 2.0 installed (the
ones available in the Ubuntu 14.04 repositories).

Really is there already pgRouting for 14.04?

I'm reading the documentation for 2.0 and will read the workshop, but it
does not look like there is a migration chapter.

Wrapping up, is there (or will be) any migration guide?

A few hints maybe:

   - If you only used "core" functions of Dijkstra or A* you should be OK
   to change the function name and make small modifications as the column
   names of the result are slightly different.
   - If you used Shooting Star algorithm, then you need to look at TRSP,
   because Shooting Star was removed
   - If you used wrapper functions, then you now need to write them
   yourself.

Best,
Daniel

Regards.
Javier Monge.
_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

On 11/25/2013 5:47 AM, Javier Mr wrote:

Hi,

I have an application that uses pgRouting v1. I was wondering if it
is possible to easily migrate from version 1 to version 2 of
pgRouting. I noticed that the pgRouting v2 announcement stated that
v2 is not baskwards compatible, is there any guide / list of steps to
get it working using v2.

I already have postgres 9.3, postgis2.1 and pgrouting 2.0 installed
(the ones available in the Ubuntu 14.04 repositories).

I'm reading the documentation for 2.0 and will read the workshop, but
it does not look like there is a migration chapter.

Wrapping up, is there (or will be) any migration guide?

The closest thing that we came up with in this regard is a pgrouting_legacy.sql that is here:
https://github.com/pgRouting/pgrouting/blob/master/src/common/sql/pgrouting_legacy.sql

Do not expect this file to work? but you can use it as an example of how you some of the old commands could be mapped to the new ones. This file has not been tested or validated in any way, but I put it together with the thought that it might help someone with understanding how to migrate 1.x to 2.0.

Hope it helps,
   -Steve

El Lunes 25 de noviembre de 2013 12:29, Daniel Kastl daniel@georepublic.de escribió:

On Mon, Nov 25, 2013 at 7:47 PM, Javier Mr <javiersdevmail@ymail.com> wrote:

Hi,

I have an application that uses pgRouting v1. I was wondering if it is possible to easily migrate from version 1 to version 2 of pgRouting. I noticed that the pgRouting v2 announcement stated that v2 is not baskwards compatible, is there any guide / list of steps to get it working using v2.

No there is no migration guide.
Anyone, who wants to contribute one is welcome. :wink:

Ok, at least for me has been really easy. In my case i just changed the shortest_path_astar method to pgr_astar and done a selection over the result set of that to just select id1, id2 and cost (leaving out seq), and with that the result of the v1 and v2 are the same.

I already have postgres 9.3, postgis2.1 and pgrouting 2.0 installed (the ones available in the Ubuntu 14.04 repositories).

Really is there already pgRouting for 14.04?

Well, it is in Debian Sid (unstable), Ubuntu 14.04 pulled it from there. (So yes is there in the development branch and it’s really easy to set up a pgRouting enviroment, just a package, easy, easy).

I’m reading the documentation for 2.0 and will read the workshop, but it does not look like there is a migration chapter.

Wrapping up, is there (or will be) any migration guide?

A few hints maybe:

  • If you only used “core” functions of Dijkstra or A* you should be OK to change the function name and make small modifications as the column names of the result are slightly different.
  • If you used Shooting Star algorithm, then you need to look at TRSP, because Shooting Star was removed
  • If you used wrapper functions, then you now need to write them yourself.
    Best,

Daniel

Regards.
Javier

Regards.
Javier Monge.


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users


Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

I already have postgres 9.3, postgis2.1 and pgrouting 2.0 installed (the
ones available in the Ubuntu 14.04 repositories).

Really is there already pgRouting for 14.04?

Well, it is in Debian Sid (unstable), Ubuntu 14.04 pulled it from there.
(So yes is there in the development branch and it's really easy to set up a
pgRouting enviroment, just a package, easy, easy).

Wow, I didn't know someone already added pgRouting to Debian.

Daniel

--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de