[postgis-users] gdal version with PostGIS

[Lars Aksel Opsahl]

Hi

Whats the policy for build scripts for postgis for new versions of gdal?

When I installed with yum on Centos 7 (X86), I got GDAL 2.3.2 

POSTGIS="2.5.2 r17328" [EXTENSION] PGSQL="110" GEOS="3.7.1-CAPI-1.11.1 27a5e771" SFCGAL="1.3.1" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.3.2, released 2018/09/21" LIBXML="2.9.1" LIBJSON="0.11" TOPOLOGY RASTER

We are no testing on an arm server and there I had to compile postgis/postgres from source and then I picked latest gdal and that compiled without any errors. 

POSTGIS="2.5.3 r17699" [EXTENSION] PGSQL="110" GEOS="3.7.2-CAPI-1.11.2 b55d2125" SFCGAL="1.3.7" PROJ="Rel. 6.2.0, September 1st, 2019" GDAL="GDAL 3.1.0dev-7a9a0f4-dirty, released 2019/99/99" LIBXML="2.9.1" TOPOLOGY RASTER

What can we go to get a new version of gdal in the next postgis 2.5  for CentOS x86 ?

Thanks 

Lars

[Darafei "Komяpa" Praliaskouski]

Hello,

According to repology, CentOS 7 doesn't even ship PostGIS. See table at the end of https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS - it contains all distributions.

If you are installing from some custom repository - which one is that? Please find that repository's GDAL maintainer. It may happen that you find their contact details on RPM file's metadata.

_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

--

Darafei Praliaskouski

Support me: http://patreon.com/komzpa

[Regina Obe]

Yum.postgresql.org ships for CentOS.  That’s what I use.

[Daniel Baston]

> According to repology, CentOS 7 doesn't even ship PostGIS. See table at the end of https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS - it contains all distributions.

The CentOS packages would be under "EPEL 7"

Dan

[Lars Aksel Opsahl]

Hi

I have also used 

https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm  .

and when I check out https://yum.postgresql.org/11/redhat/rhel-7.8-x86_64/ the most recent gdal is  gdal23-libs-2.3.2-8.rhel7.x86_64.rpm  .

I can check out with Devrim .

I have never checked the in table at https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS .

I assume that some of us that CentOs have that page then ?

Thanks.

Lars

---

From: postgis-users <postgis-us...@lists.osgeo.org> on behalf of Regina Obe <l...@pcorp.us>
Sent: Wednesday, September 4, 2019 4:03 PM

[Devrim Gündüz]

Hi,

On Mon, 2019-09-02 at 07:36 +0000, Lars Aksel Opsahl wrote:
> Whats the policy for build scripts for postgis for new versions of gdal?
>
> When I installed with yum on Centos 7 (X86), I got GDAL 2.3.2

I often try to pick up the latest versions in the PostgreSQL community
repositories, but GDAL is one of the exceptions. Upgrading it involves lots of
packages, including dependencies like ogdi, and it will take more time that I
ever thought.

It is on my list. See:

https://git.postgresql.org/gitweb/?p=pgrpms.git;a=commitdiff;h=e1772592e8dbf148c43dcdaf3463bed3b7ede308

I already pushed a WIP version.

In the last couple of weeks, I spent more than 100 hours for GIS RPMs, making
them stable on our repo and EPEL 8 as well. I hope GDAL 3.0 won't be that far
away.

-HTH

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

[Devrim Gündüz]

Hi,

On Wed, 2019-09-04 at 15:05 +0300, Darafei "Komяpa" Praliaskouski wrote:
> According to repology, CentOS 7 doesn't even ship PostGIS. See table at the
> end of https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS - it
> contains all distributions.

Looks like it assumes that everyone submits their repos to repology. :)

Cheers,

[Darafei "Komяpa" Praliaskouski]

On Tue, Sep 10, 2019 at 1:04 PM Devrim Gündüz <dev...@gunduz.org> wrote:

Hi,

On Wed, 2019-09-04 at 15:05 +0300, Darafei "Komяpa" Praliaskouski wrote:
> According to repology, CentOS 7 doesn't even ship PostGIS. See table at the
> end of https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS - it
> contains all distributions.

Looks like it assumes that everyone submits their repos to repology. :)

I see CentOS and EPEL there, and they seem to ship something really old. If some distro's repo is lost (not ppa or overlay), why not add it there? It's a biggest repo comparator anyway.

 

[Lars Aksel Opsahl]

> From: postgis-users <postgis-us...@lists.osgeo.org> on behalf of Devrim Gündüz <dev...@gunduz.org>

> Sent: Tuesday, September 10, 2019 11:48 AM

> To: PostGIS Users Discussion <postgi...@lists.osgeo.org>

> Subject: Re: [postgis-users] gdal version with PostGIS

>  

> 

> Hi,

> 

> On Mon, 2019-09-02 at 07:36 +0000, Lars Aksel Opsahl wrote:

> > Whats the policy for build scripts for postgis for new versions of gdal?

> > 

> > When I installed with yum on Centos 7 (X86), I got GDAL 2.3.2

> 

> I often try to pick up the latest versions in the PostgreSQL community

> repositories, but GDAL is one of the exceptions. Upgrading it involves lots of

> packages, including dependencies like ogdi, and it will take more time that I

> ever thought.

> 

> It is on my list. See:

> 

> https://git.postgresql.org/gitweb/?p=pgrpms.git;a=commitdiff;h=e1772592e8dbf148c43dcdaf3463bed3b7ede308

> 

> I already pushed a WIP version.

> 

Hi

Thanks that's nice to hear, just let us know if you want us to test something.

One more question. 

Is it any plans for makeing binaries for Postgres/Postgis running on CentOs on aarch64 (ARM64, ARMv8) CPU's ?

Lars

[Devrim Gündüz]

Hi Lars,

On Wed, 2019-09-11 at 06:08 +0000, Lars Aksel Opsahl wrote:
> Thanks that's nice to hear, just let us know if you want us to test
> something.

I already committed GDAL 3.0.1 to the git repo. I'm waiting for stabilizing
OGDI 4.1.0 RPM. Should take just a few days. I'll let you know.

> Is it any plans for makeing binaries for Postgres/Postgis running on CentOs
> on aarch64 (ARM64, ARMv8) CPU's ?

Not at the moment We (PostgreSQL.org) don't have any ARM* build instances.