Postgres Pro
Downloads
Home   >   mailing lists

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_FzuW_1yqjOwSFum=FXWXrpvfSTEqQt0VgJDyb4L20XkDefw@mail.gmail.com
Whole thread Raw
In response to Re: PostGIS 2.3 and PgRouting 2.0.3?  (Scott Mugnaini <scott.mugnaini@gmail.com>)
Responses Re: PostGIS 2.3 and PgRouting 2.0.3?
List pgsql-pkg-yum
Tree view
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.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

pgsql-pkg-yum by date:

Previous
From: Scott Mugnaini
Date:
Subject: Re: PostGIS 2.3 and PgRouting 2.0.3?
Next
From: Vicky Vergara
Date:
Subject: Re: PostGIS 2.3 and PgRouting 2.0.3?