[postgis-users] Problem raster2pgsql on Centos 8 - postgres 12 / postgis 2.5

[Regina Obe]

Lars,

 

>From your postgis output you are running unreleased version of PostGIS.  Is
that intentional?  Did you compile yourself?  I didn't think any
distribution had this particular version as it has 3.1.0dev in it.  I know
distributions have 3.1.0alpha2

 

POSTGIS="3.1.0dev 3.1.0alpha2-100-g50b1e70b1" [EXTENSION] PGSQL="120"
GEOS="3.8.1-CAPI-1.13.3" SFCGAL="1.3.7" PROJ="7.1.1" GDAL="GDAL 3.1.3,
released 2020/09/01" LIBXML="2.9.7" LIBJSON="0.13.1"

 LIBPROTOBUF="1.3.0" WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER

> 

 

Can you also output what 

 

ldd /usr/pgsql-12/lib/postgis_raster-3.so

 

returns  could be for some reason your raster piece is perhaps compild with
proj 6.3.2 and your regular PostGIS is proj 7.1.1

 

 

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
Of Lars Aksel Opsahl
Sent: Thursday, November 5, 2020 5:19 AM
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] Problem raster2pgsql on Centos 8 - postgres 12
/ postgis 2.5

 

 

>From: postgis-users <postgis-users-bounces at lists.osgeo.org
<mailto:postgis-users-bounces at lists.osgeo.org> > on behalf of Jorge Gustavo
Rocha <jgr at di.uminho.pt <mailto:jgr at di.uminho.pt> >Sent: Thursday, November
5, 2020 10:44 AMTo: postgis-users at lists.osgeo.org
<mailto:postgis-users at lists.osgeo.org>  <postgis-users at lists.osgeo.org
<mailto:postgis-users at lists.osgeo.org> >Subject: Re: [postgis-users] Problem
raster2pgsql on Centos 8 - postgres 12 / postgis 2.5 

> 

>Hi Lars,

> 

>I would start by removing the old libproj.so.15. You still have an old

>PROJ lib around.


Hi 

 

I tested this now and then we get this error

 

"create extension pg_stat_statements; create extension postgis; create
extension postgis_topology; create extension postgis_raster ;" 

ERROR:  could not load library "/usr/pgsql-12/lib/postgis_raster-3.so":
libproj.so.15: cannot open shared object file: No such file or directory

 

Thanks

 

Lars

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20201105/5d8118e8/attachment.html>