[postgis-users] gdal version for Postgis 2.4
Zwettler Markus (OIZ)
I am in the same situation:
<quote>
I found that Postgis 24 depends on gdal30-libs.x86_64 0:3.0.4-2.
But this installation creates an error :
dbname=# create extension postgis;
ERROR: could not load library "/usr/pgsql-11/lib/rtpostgis-2.4.so":
/usr/gdal30/lib/libgdal.so.26: undefined symbol: GEOSMakeValid_r
And I found that postgis 24 actually depends on gdal23.
</quote>
My Postgis 2.4 rpm also seems to depend on gdal30-libs-3.0.4:
<quote>
BuildArch: x86_64
Name: postgis24_96
Version: 2.4.8
Release: 7.rhel7
...
Requires: gdal30-libs >= 3.0.4
</quote>
QUESTIONS:
Does Postgis 2.4 depend on gdal23?
Is there a bug with the rpm dependency?
How to fix this?
$ uname -a
Linux szhm49251 3.10.0-1062.12.1.el7.x86_64 #1 SMP Thu Dec 12 06:44:49 EST 2019 x86_64 x86_64 x86_64 GNU/Linux
$ rpm -aq | grep postgres
postgresql96-contrib-9.6.17-1PGDG.rhel7.x86_64
postgresql96-libs-9.6.17-1PGDG.rhel7.x86_64
postgresql96-server-9.6.17-1PGDG.rhel7.x86_64
postgresql96-devel-9.6.17-1PGDG.rhel7.x86_64
postgresql96-9.6.17-1PGDG.rhel7.x86_64
postgresql96-plpython-9.6.17-1PGDG.rhel7.x86_64
$ rpm -aq | grep postgis
postgis24_96-2.4.8-7.rhel7.x86_64
postgis24_96-client-2.4.8-7.rhel7.x86_64
$ rpm -qa | grep gda
gdal-libs-1.11.4-12.rhel7.x86_64
gdal30-libs-3.0.4-1.rhel7.x86_64
gdal23-libs-2.3.2-8.rhel7.x86_64
Paul Ramsey
> On Mar 9, 2020, at 8:51 AM, Zwettler Markus (OIZ) <Markus....@zuerich.ch> wrote:
>
> QUESTIONS:
> Does Postgis 2.4 depend on gdal23?
Not at a source code level. It’s probably possible to compile PostGIS 2.4 against more modern GDAL.
> Is there a bug with the rpm dependency?
Yes.
> How to fix this?
Remove the new gdal and put an old one back in. Run ldconfig to refresh the linker. Report the mistake to the pgdg yum redmine bug tracker.
P
_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
Zwettler Markus (OIZ)
postgis24_96-2.4.8-7.rhel7.x86_64
postgis24_96-client-2.4.8-7.rhel7.x86_64
[root@tstm49003 lib]# rpm -aq | grep gdal
gdal-libs-1.11.4-12.rhel7.x86_64
gdal23-libs-2.3.2-8.rhel7.x86_64
gdal30-libs-3.0.4-2.rhel7.x86_64
[root@tstm49003 lib]# rpm -e gdal30-libs-3.0.4-2.rhel7.x86_64 --nodeps
[root@tstm49003 lib]# rpm -aq | grep gdal
gdal-libs-1.11.4-12.rhel7.x86_64
gdal23-libs-2.3.2-8.rhel7.x86_64
[root@tstm49003 lib]# cat /etc/ld.so.conf.d/gdal23-pgdg-libs.conf
/usr/gdal23/lib/
[root@tstm49003 lib]# ldconfig
Result: ERROR: could not load library "/usr/pgsql-9.6/lib/rtpostgis-2.4.so": libgdal.so.26: cannot open shared object file: No such file or directory
[root@tstm49003 lib]# ldd /usr/pgsql-9.6/lib/rtpostgis-2.4.so
linux-vdso.so.1 => (0x00007ffcf81f2000)
libgdal.so.26 => not found
libgeos_c.so.1 => /usr/geos37/lib64/libgeos_c.so.1 (0x00007fa7e350f000)
...
My rpm (coming from the official pgdg channel) is build against gdal 3.0.4.
Is there an rpm build against gdal23?
-Markus
> -----Ursprüngliche Nachricht-----
> Von: postgis-users <postgis-us...@lists.osgeo.org> Im Auftrag von
> Paul Ramsey
> Gesendet: Montag, 9. März 2020 17:20
> An: PostGIS Users Discussion <postgi...@lists.osgeo.org>
> Betreff: Re: [postgis-users] gdal version for Postgis 2.4
Regina Obe
How many PostgreSQL versions do you have installed? And do you use gdal for anything besides PostgreSQL?
> > -----Urspr ngliche Nachricht-----
> > Von: postgis-users <postgis-us...@lists.osgeo.org> Im Auftrag
> > von Paul Ramsey
> > Gesendet: Montag, 9. M rz 2020 17:20
Zwettler Markus (OIZ)
We have only one version installed (9.6). We don't use gdal for anything else.
Anyway. We found that the problem is based on a wrong dependency within the postgis24 package. There is a ticket within PGDG RedMine about it.
Thanks,
Markus
> -----Ursprüngliche Nachricht-----
> Gesendet: Dienstag, 10. März 2020 18:11