[pgrouting-users] best/fastest way to calculate thousands of trsp routes

McDonaldR McDonaldR at angus.gov.uk
Fri Jun 16 08:42:54 PDT 2017

Thanks for this, Regina

I finally got around to sorting this all out and your instructions worked perfectly.

Running pgRouting 2.4.1 across the board now.


-----Original Message-----
From: Pgrouting-users [mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of Regina Obe
Sent: 28 April 2017 15:29
To: 'pgRouting users mailing list'
Subject: Re: [pgrouting-users] best/fastest way to calculate thousands of trsp routes


To avoid any issues with the upgrade machinery, especially since you are coming from such an old version,  I would do



Doing DROP EXTENSION without doing CASCADE is pretty safe.  It will bail out if any of your tables, views, etc have dependencies on pgRouting functions /types and will tell you what you need to temporarily backup and drop for it to continue.

If you don't have such dependencies (which is usually the case), the drop will run fine.

Now it won't catch things like dependencies within plpgsql functions.  This is fine since the recreate extension should put most / if not all of them back.

This feature also allows you to downgrade. Note that the upgrade machinery doesn't allow downgrading.
I use this approach all the time for quickly swapping between newer and older / older and newer pgRouting versions to spot regression issues.

So to downgrade you'd do


The nice thing is since the dlls in 2.4.1 are versioned (I forget if they were in 2.1.0) and dependencies are the same (you'll want to use the boost and cgal libs from 2.4 since I think the boost and CGAL I ship is newer than what I shipped with 2.1 but downward compatible with older), both versions can coexist on the same PostgreSQL cluster, though you can have only one version installed in any given database.

Hope that helps,

>Vicky Vergara vicky at georepublic.de
> Wed Apr 26 11:37:46 PDT 2017
> Please, save all your tables, views, functions, etc before upgrading,
> is a bug on the upgrading script that hasnt being fix, (recently found
> it)

> On Wed, Apr 26, 2017 at 3:55 AM, McDonaldR <McDonaldR at angus.gov.uk>

>> Wow! Thanks for that, Regina.
>> I've downloaded the file and will apply it as soon as I can.
>> Most of my pgRouting work has been done on 2.1 so it will be good see
>> how much has changed in 2.4.
>> Ross

Pgrouting-users mailing list
Pgrouting-users at lists.osgeo.org

This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment.

More information about the Pgrouting-users mailing list