Re: PostGIS 2.3 and PgRouting 2.0.3?

From: Vicky Vergara <vicky(at)georepublic(dot)de>
To: Scott Mugnaini <scott(dot)mugnaini(at)gmail(dot)com>
Cc: Devrim Gündüz <devrim(at)gunduz(dot)org>, Christoph Berg <cb(at)df7cb(dot)de>, pgsql-pkg-yum <pgsql-pkg-yum(at)postgresql(dot)org>
Subject: Re: PostGIS 2.3 and PgRouting 2.0.3?
Date: 2016-12-01 02:49:51
Message-ID: CAK_FzuW_1yqjOwSFum=FXWXrpvfSTEqQt0VgJDyb4L20XkDefw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-yum

Hello,
I am a pgRouting developer.
I must say that I don't expect to be a problem on CENTOS 7

pgRouting relies heavily on C++0x code, you can see the difference of the
things that can be done on the g++4.4 used by Centos 6 and the g++4.8 used
in Centos 7
https://gcc.gnu.org/gcc-4.4/cxx0x_status.html
https://gcc.gnu.org/gcc-4.8/cxx0x_status.html

So about Centos 6
I dedicated some time to make a 2.1 version compilable with g++4.4
can be found here:
https://github.com/pgRouting/pgrouting/releases/tag/experiment%2Fg%2B%2B4.4compilable-lw
here you can see the usual tests we make:
https://travis-ci.org/pgRouting/pgrouting/builds/177448596
and the tasks I made:
https://github.com/cvvergara/pgrouting/issues/60

I tagged it as experiment as I don't have a centos 6 to try on.

When I compile it locally on my computer and try to link it to postgresql I
get this kind of warnings:
my guess is because postgresql I have is not compiled with 4.4

[ 94%] Building C object src/vrp_basic/src/CMakeFiles/vrp_basic.dir/VRP.c.o
/home/vicky/pgrouting/pgrouting/pgrouting/src/vrp_basic/src/VRP.c: In
function ‘finish’:
/home/vicky/pgrouting/pgrouting/pgrouting/src/vrp_basic/src/VRP.c:149:
warning: implicit declaration of function ‘__builtin_unreachable’

after compilation when I start executing the tests the extension does not
load because __builtin_unreachable is not defined:
CREATE EXTENSION ERROR: could not load library "/usr/lib/postgresql/9.3/lib/
librouting-2.1.so": /usr/lib/postgresql/9.3/lib/librouting-2.1.so:
undefined symbol: __builtin_unreachable ERROR: function pgr_version() does
not exist LINE 1: select pgr_version()

__builtin_unreachable started on GCC 4.5:
https://gcc.gnu.org/onlinedocs/gcc-4.5.4/gcc/Other-Builtins.html

On Wed, Nov 30, 2016 at 4:30 PM, Scott Mugnaini <scott(dot)mugnaini(at)gmail(dot)com>
wrote:

> Any chance/possibility that 2.3.1 will make it to CentOS repo?
> http://docs.pgrouting.org/2.3/en/doc/index.html
> Thanks again,
> Scott
>
>
> On Sun, Oct 2, 2016 at 4:14 PM, Devrim Gündüz <devrim(at)gunduz(dot)org> wrote:
>
>>
>> Ouch.
>>
>> So, pgrouting folks are working on a new 2.2 that will includes fixes for
>> this
>> *and* gcc 4.4. I'll keep the list updated.
>>
>> Regards, Devrim
>>
>> On Fri, 2016-09-30 at 16:12 +0200, Christoph Berg wrote:
>> > Re: Devrim Gündüz 2016-09-30 <1475240709(dot)24885(dot)136(dot)camel(at)gunduz(dot)org>
>> > >
>> > >
>> > > Hi Scott,
>> > >
>> > > On Fri, 2016-09-30 at 15:41 +0300, Scott Mugnaini wrote:
>> > > >
>> > > > It installs but I get error below on creating extension:
>> > > > create extension pgrouting;
>> > > > ERROR: could not load library "/usr/pgsql-9.6/lib/librouting.so":
>> > > > /usr/pgsql-9.6/lib/librouting.so: undefined symbol: heap_formtuple
>> > >
>> > > Yeah, I was working on that. This does not happen in PostgreSQL
>> > > 9.4+pgrouting
>> > > 2.0, so it must be something about PostgreSQL or so. I'll bug the
>> pgrouting
>> > > folks.
>> >
>> > commit 726117243022178e72966cbffdfb9147ec6dbbcc
>> > Author: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
>> > Date: Thu Jul 2 21:18:04 2015 +0300
>> >
>> > Remove obsolete heap_formtuple/modifytuple/deformtuple functions.
>> >
>> > These variants used the old-style 'n'/' ' NULL indicators. The
>> new-style
>> > functions have been available since version 8.1. That should be long
>> > enough
>> > that if there is still any old external code using these functions,
>> they
>> > can just switch to the new functions without worrying about
>> backwards
>> > compatibility
>> >
>> > Peter Geoghegan
>> >
>> >
>> >
>> > Christoph
>>
>> --
>> Devrim GÜNDÜZ
>> EnterpriseDB: http://www.enterprisedb.com
>> PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
>> Twitter: @DevrimGunduz , @DevrimGunduzTR
>>
>
>

--

Georepublic UG (haftungsbeschränkt)
Salzmannstraße 44,
81739 München, Germany

Vicky Vergara
Operations Research

eMail: vicky(at)georepublic(dot)de
Web: https://georepublic.info

Tel: +49 (089) 4161 7698-1
Fax: +49 (089) 4161 7698-9

Commercial register: Amtsgericht München, HRB 181428
CEO: Daniel Kastl

In response to

Responses

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Vicky Vergara 2016-12-01 02:59:39 Re: PostGIS 2.3 and PgRouting 2.0.3?
Previous Message Scott Mugnaini 2016-11-30 22:30:53 Re: PostGIS 2.3 and PgRouting 2.0.3?