Date: Fri, 13 Nov 2020 23:53:00 +0000 From: Devrim Gündüz <dev...@gunduz.org<mailto:dev...@gunduz.org>> To: PostGIS Users Discussion <postgis-users@lists.osgeo.org<mailto:postgis-users@lists.osgeo.org>> Subject: Re: [postgis-users] Problem raster2pgsql on Centos 8 - postgres 12 / postgis 2.5 Hi, On Mon, 2020-11-02 at 08:17 +0000, Alain Benard wrote: > I have a problem with rasterpgsql with all file geotiff. > > On a server Centos 7 / Postgres 9.5 / postgis 2.5 : > /usr/pgsql-9.5/bin/raster2pgsql -b 1 -I -C -F -t 50x50 -s 2154 > filename.geotiff tablename > script.sql : it's OK. > > On a server Centos 8 / Postgres 12 / postgis 2.5 : (with the same > geotiff file) > /usr/pgsql-12/bin/raster2pgsql -b 1 -I -C -F -t 50x50 > -s 2154 filename.geotiff tablename > script.sql : error The > script.sql file is not completed and the error is : > free(): invalid pointer Abandon (core dumped)
Can you please fully update the packages? It should pick up PROJ 7.2.0, GDAL 3.2.0, etc. This was a RPM packaging issue, and should be fixed now. Also, can you please remove OS-supplied PROJ packages as well? dnf remove proj-* Regards, -- Devrim Gündüz on 16/11/2020 I wrote : Hi, In my case the problem persist. Perhaps i use an other depot. For installing postgres postgis on a new virtual machine with Centos 8 i use a script: (https://computingforgeeks.com/how-to-install-postgresql-12-on-centos-7/) (https://computingforgeeks.com/how-to-install-postgis-on-centos-8-linux/) The principals commands are : dnf -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm dnf -qy module disable postgresql dnf -y install postgresql12-server postgresql12-devel postgresql12-contrib dnf -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm dnf config-manager --set-enabled PowerTools dnf -y install postgis25_12 postgis25_12-docs postgis25_12-utils postgis25_12-client Two version of proj are installed with the script (even if i erase proj before with ' dnf remove proj-*') : dnf list installed |grep proj proj.x86_64 6.3.2-4.el8 @epel proj72.x86_64 7.2.0-1.rhel8 @pgdg-common The result : I can't use 'CREATE EXTENSION POSTGIS' : ERREUR: n'a pas pu charger la bibliothèque « /usr/pgsql-12/lib/rtpostgis-2.5.so » : /usr/gdal32/lib/libgdal.so.28: undefined symbol: GTIFGetGCSInfoEx Thank you for explaining. Alain. Today (18/11/2020) I try to reinstall on a new virtual machine with Centos 8. dnf upgrade dnf -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm dnf -qy module disable postgresql dnf -y install postgresql12-server postgresql12-devel postgresql12-contrib dnf -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm dnf install dnf-plugins-core dnf config-manager --set-enabled PowerTools dnf install postgis25_12 I created a database and ‘CREATE EXTENSION POSTGIS ;’ failed : ERREUR: n'a pas pu charger la bibliothèque « /usr/pgsql-12/lib/rtpostgis-2.5.so » : /usr/gdal32/lib/libgdal.so.28: undefined symbol: GTIFGetGCSInfoEx ldd /usr/pgsql-12/lib/rtpostgis-2.5.so |grep proj libproj.so.19 => /usr/proj72/lib/libproj.so.19 (0x00007ff4cfa59000) libproj.so.15 => /lib64/libproj.so.15 (0x00007ff4c08c5000) It’s easy to reproduce this problem. The repository is corrupted and it’s impossible to install from it. I don’t know if this problem take a response on this list but we have some server without update because of this problem. Thanks for advance. Alain.
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users