Re: PostGIS 2.3 and PgRouting 2.0.3? - Mailing list pgsql-pkg-yum

From Vicky Vergara
Subject Re: PostGIS 2.3 and PgRouting 2.0.3?
Date
Msg-id CAK_FzuX_Dz75u5r5BOFm=rOGqgKWGnj8nVV-YmLhXiYhjVszbA@mail.gmail.com
Whole thread Raw
In response to Re: PostGIS 2.3 and PgRouting 2.0.3?  (Vicky Vergara <vicky@georepublic.de>)
List pgsql-pkg-yum
hello again.
(I miss clicked and sent before finishing the last mail)

So.. the tag

experiment/g++4.4compilable-lw

Is thought for centos6, has pgRouting 2.1 compilable with g++4.4 and it can be used with postgres9.6 and has some wrappers to use better code where possible.

As a reminder I don't expect problems for CENTOS 7 and pgRouting version 2.3.1.

Regards

Vicky






On Wed, Nov 30, 2016 at 8:49 PM, Vicky Vergara <vicky@georepublic.de> wrote:
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
here you can see the usual tests we make:
https://travis-ci.org/pgRouting/pgrouting/builds/177448596
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.mugnaini@gmail.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@gunduz.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.24885.136.camel@gunduz.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.linnakangas@iki.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@georepublic.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




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

Vicky Vergara
Operations Research

eMail: vicky@georepublic.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

pgsql-pkg-yum by date:

Previous
From: Vicky Vergara
Date:
Subject: Re: PostGIS 2.3 and PgRouting 2.0.3?
Next
From: Jonathon Nelson
Date:
Subject: a bunch of potential improvements to the postgresql spec files