Обсуждение: PostGIS 2.3 and PgRouting 2.0.3?

Поиск
Список
Период
Сортировка

PostGIS 2.3 and PgRouting 2.0.3?

От
Scott Mugnaini
Дата:
Hi -
I saw that both PostGIS 2.3 and PgRouting 2.0.3 would be in the 9.6 release.
In the current RC for CentOS 6.x64, neither is available.
Will these only be added for the actual release?
Thanks,
Scott

Re: PostGIS 2.3 and PgRouting 2.0.3?

От
Devrim Gündüz
Дата:
Hi,

On Tue, 2016-09-27 at 22:44 +0300, Scott Mugnaini wrote:
> I saw that both PostGIS 2.3 and PgRouting 2.0.3 would be in the 9.6 release.

(Assuming that you mean pgrouting 2.3.0), yes they will be.

> In the current RC for CentOS 6.x64, neither is available.
> Will these only be added for the actual release?

Yes, I'm rebuilding all packages from scratch for 9.6 release, and they will be
released tomorrow. These 2 packages are already done.

Regards,

--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Вложения

Re: PostGIS 2.3 and PgRouting 2.0.3?

От
Scott Mugnaini
Дата:
PgRouting is missing from CentOS 6x.64 production
Will it still be added?
Thanks again,
Scott

On Wed, Sep 28, 2016 at 1:08 PM, Devrim Gündüz <devrim@gunduz.org> wrote:

Hi,

On Tue, 2016-09-27 at 22:44 +0300, Scott Mugnaini wrote:
> I saw that both PostGIS 2.3 and PgRouting 2.0.3 would be in the 9.6 release.

(Assuming that you mean pgrouting 2.3.0), yes they will be.

> In the current RC for CentOS 6.x64, neither is available.
> Will these only be added for the actual release?

Yes, I'm rebuilding all packages from scratch for 9.6 release, and they will be
released tomorrow. These 2 packages are already done.

Regards,

--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: PostGIS 2.3 and PgRouting 2.0.3?

От
Devrim Gündüz
Дата:
Hi Scott,

On Thu, 2016-09-29 at 19:27 +0300, Scott Mugnaini wrote:
> PgRouting is missing from CentOS 6x.64 production
> Will it still be added?

Sorry, had build errors with 2.3.0 on RHEL 6. I submitted the issue to
developers, and waiting a response from them.

Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Вложения

Re: PostGIS 2.3 and PgRouting 2.0.3?

От
Devrim Gündüz
Дата:
Hi,

On Thu, 2016-09-29 at 19:27 +0300, Scott Mugnaini wrote:
> PgRouting is missing from CentOS 6x.64 production
> Will it still be added?

2.3 and 2.2 cannot be compiled on RHEL 6, so I pushed 2.0.1 to the testing
repository. It will be available in an hour. Once it is there, you can install
it with 

yum --enablerepo pgdg96-updates-testing install pgrouting_96

if you have have the latest repository RPM. Please let me know if it works, so
that I can push it to the stable repository.

Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Вложения

Re: PostGIS 2.3 and PgRouting 2.0.3?

От
Scott Mugnaini
Дата:
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
david=#
Thanks,
Scott

On Fri, Sep 30, 2016 at 10:27 AM, Devrim Gündüz <devrim@gunduz.org> wrote:

Hi,

On Thu, 2016-09-29 at 19:27 +0300, Scott Mugnaini wrote:
> PgRouting is missing from CentOS 6x.64 production
> Will it still be added?

2.3 and 2.2 cannot be compiled on RHEL 6, so I pushed 2.0.1 to the testing
repository. It will be available in an hour. Once it is there, you can install
it with 

yum --enablerepo pgdg96-updates-testing install pgrouting_96

if you have have the latest repository RPM. Please let me know if it works, so
that I can push it to the stable repository.

Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: PostGIS 2.3 and PgRouting 2.0.3?

От
Devrim Gündüz
Дата:
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.

Thanks for testing it.

Regards,


--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Вложения

Re: PostGIS 2.3 and PgRouting 2.0.3?

От
Christoph Berg
Дата:
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

Вложения

Re: PostGIS 2.3 and PgRouting 2.0.3?

От
Devrim Gündüz
Дата:
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

Вложения

Re: PostGIS 2.3 and PgRouting 2.0.3?

От
Scott Mugnaini
Дата:
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

Re: PostGIS 2.3 and PgRouting 2.0.3?

От
Vicky Vergara
Дата:
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

Re: PostGIS 2.3 and PgRouting 2.0.3?

От
Vicky Vergara
Дата:
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