[pgrouting-dev] Ist there a chance to provide pgRouting extension 2.6.x or 3.1.x as rpm packages released for SLES12 SP5 and SLES15 SP2

Kampf_Heiko_OWL-IT · January 21, 2021, 6:40am

Dear pgRouting development Team,

as far as we could see, there doesn’t seem to be any pgRouting extension rpm packages available

at https://pgrouting.org/download.html, that is released for SUSE Linux Enterprise Server.

Is there a chance to provide rpm packages, released for SLES12 SP5 or SLES15 SP2, in the next time?

If not, can you recommend what kind of source code version can be used, when runnig Linux SLES12 SP5.

We have installed postgreSQL 10 and postgreSQL 11 version including postGIS 30 extension in our environment.

We got trouble when trying to run cmake/make with pgRouting extension version 3.1.2 about missing boost and some xxx.hpp files.

We downloaded boost_1_54_0.tar from your download site and copied the files to include/boost directory

but run into trouble of some missing varaibles or „wrong“ search paths for the copied xxx.hpp files.

The post-dev package version that comes with SLES12 SP5 is 1.54, that‘s the reason for using the files from boost_1_54_0.tar.

However: With pgRouting version 2.6.3 cmake/make and make install worked fine, so we are going to test this version, soon.

Many thanks

Kind regards

Heiko Kämpf

Ostwestfalen-Lippe-IT Paderborn
Technologiepark 11
33100 Paderborn
Germany

E-Mail: h.kaempf2@owl-it.de

cvvergara · January 26, 2021, 3:45pm

Hello

comments on the text

Regards

Vicky

Dear pgRouting development Team,

as far as we could see, there doesn’t seem to be any pgRouting extension rpm packages available

at https://pgrouting.org/download.html, that is released for SUSE Linux Enterprise Server.

We are not responsible of SUSE linux Enterprise Server.

Is there a chance to provide rpm packages, released for SLES12 SP5 or SLES15 SP2, in the next time?

If not, can you recommend what kind of source code version can be used, when runnig Linux SLES12 SP5.

The SUSE linux Enterprise Server team, would be the ones to package pgRouting for their OS

We have installed postgreSQL 10 and postgreSQL 11 version including postGIS 30 extension in our environment.

We got trouble when trying to run cmake/make with pgRouting extension version 3.1.2 about missing boost and some xxx.hpp files.

We downloaded boost_1_54_0.tar from your download site and copied the files to include/boost directory

but run into trouble of some missing varaibles or „wrong“ search paths for the copied xxx.hpp files.

The post-dev package version that comes with SLES12 SP5 is 1.54, that‘s the reason for using the files from boost_1_54_0.tar.

However: With pgRouting version 2.6.3 cmake/make and make install worked fine, so we are going to test this version, soon.

I must mention if you are using pgRouting version 2.x that uses a dependency called CGAL, Just make sure that the CGAL installed

is not 5 or greater. Starting from 3.0.0 we do not use CGAL and we stopped the maintenance of v2.x Because the change in CGAL

produced many build problems.

We just made a new release, 3.1.3, which is the latest version.

HINT:

When I want to install software from GitHub, I try to inspect the test files to see what I have to do to make it work
This is where the dependencies get installed for pgRouting
https://github.com/pgRouting/pgrouting/blob/master/.github/workflows/ubuntu.yml#L44

That includes a dependency to perform the tests.

Note that each section (defined with the name) start from the root of the repository.

If you get stuck building and installing pgRouting don’t hesitate to ask.

···

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

Vicky Vergara
Operations Research

eMail: vicky@[georepublic.de](http://georepublic.de)
Web: [https://georepublic.info](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

Devrim_GUNDUZ · January 27, 2021, 1:51am

Hi,

(PostgreSQL RPM packager speaking)

On Thu, 2021-01-21 at 06:40 +0000, Kämpf, Heiko (OWL-IT) wrote:

as far as we could see, there doesn't seem to be any pgRouting
extension rpm packages available
at https://pgrouting.org/download.html, that is released for SUSE
Linux Enterprise Server.
Is there a chance to provide rpm packages, released for SLES12 SP5 or
SLES15 SP2, in the next time?
If not, can you recommend what kind of source code version can be
used, when runnig Linux SLES12 SP5.

SLES 12 is too old to compile newer versions of pgRouting. However I
just pushed pgRouting 3.1.3 and 3.0.5 RPMs to the official PostgreSQL
ZYPP repository at https://zypp.postgresql.org . To use the repo,
please follow the instructions at :

https://zypp.postgresql.org/howtozypp/

Let me know if you have issues/questions.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Kampf_Heiko_OWL-IT · January 27, 2021, 10:11am

Dear Devrim Gündüz,

many thanks for your statement about providing pgRouting extensions.
As we could see, also postGIS rpm's have been provided for postgreSQL11, 12 and 13 within SLES15, SLES 15 SP1 and SLES15 SP2 repositories, yesterday.

Currently we are running potgreSQL 10 and 11 together with postGIS 30 and pgRouting 2.6.3 (our own rpm build from your souce code files)
So it might make sense to think about a possible update to our environment, since postGIS 3.x ist also now available within SLES15.

From the point of view of a postgreSQL developer, does it make sense to run SLES15 SP2 instead of SLES12 SP5, now that postGiS and pgRouting is available
on the offivial download sites, to insure possible support from your team and to be save about possible implemention of new functions to our environment.

Many thanks
Kind regards
Heiko

-----Ursprüngliche Nachricht-----
Von: pgrouting-dev <pgrouting-dev-bounces@lists.osgeo.org> Im Auftrag von Devrim Gündüz
Gesendet: Mittwoch, 27. Januar 2021 02:51
An: pgRouting developers mailing list <pgrouting-dev@lists.osgeo.org>
Betreff: Re: [pgrouting-dev] Ist there a chance to provide pgRouting extension 2.6.x or 3.1.x as rpm packages released for SLES12 SP5 and SLES15 SP2

Hi,

(PostgreSQL RPM packager speaking)

On Thu, 2021-01-21 at 06:40 +0000, Kämpf, Heiko (OWL-IT) wrote:

as far as we could see, there doesn't seem to be any pgRouting
extension rpm packages available at
https://pgrouting.org/download.html, that is released for SUSE Linux
Enterprise Server.
Is there a chance to provide rpm packages, released for SLES12 SP5 or
SLES15 SP2, in the next time?
If not, can you recommend what kind of source code version can be
used, when runnig Linux SLES12 SP5.

SLES 12 is too old to compile newer versions of pgRouting. However I just pushed pgRouting 3.1.3 and 3.0.5 RPMs to the official PostgreSQL ZYPP repository at https://zypp.postgresql.org . To use the repo, please follow the instructions at :

https://zypp.postgresql.org/howtozypp/

Let me know if you have issues/questions.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR