From: "Regina Obe" <lr@pcorp.us>
To: <pgsql-pkg-yum@postgresql.org>
Cc: =?iso-8859-1?Q?'Devrim_G=FCnd=FCz'?= <devrim@gunduz.org>
Subject: PostGIS 3.1 still has a dependency on SFCGAL but it should not
Date: Thu, 10 Jun 2021 15:05:14 -0400
Message-ID: <000701d75e2b$8ca49540$a5edbfc0$@pcorp.us>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Thread-Index: AddeKw1jG+hchFuiRSCeznM8r6/djw==
Content-Language: en-us
Archived-At: 
 <https://www.postgresql.org/message-id/000701d75e2b%248ca49540%24a5edbfc0%24%40pcorp.us>
Precedence: bulk

Can you check and see why the Yum postgis 3.1.2 still has a dependency on
SFCGAL. I'm not sure if it's a hard-coding you have in place or I missed
something when removing from PostGIS 3.1

In PostGIS 3.1 I removed the dependency on sfcgal from the core library so
that there are two .sos

postgis-3.so
postgis_sfcgal-3.so

But after installing postgis 3.1.2 on CentOS 7 and AMZN-2-Linux I still see
the dependency and it's causing an issue with my ability to do 

CREATE EXTENSION postgis; 

on AMZN-2 -Linux cause I presume the micro version amzn-2 boost-1.5.3.28 is
incompatible (gives error _ZN5boost7archive18text_iarchive_implIN50_13_..)
with 
the epel one you were expecting of boost-1.5.3.30

Anyway that's how discovered that yum.postgresql.org postgis-3 build still
has a dependency on SFCGAL.

That said, I thought maybe I missed something.  I checked my windows build,
and these are separate and all the Boost/SFCGAL  dependency is in
postgis_sfcgal.so.


I checked yum 3.1 install on my CentOS-7 testing box -
yum install postgis31_12 

ldd -d /usr/pgsql-12/lib/postgis-3.so

and I see these lines
        libSFCGAL.so.1 => /lib64/libSFCGAL.so.1 (0x00007f44b96d1000)
        libCGAL.so.11 => /usr/lib64/libCGAL.so.11 (0x00007f44b799d000)
        libCGAL_Core.so.11 => /usr/lib64/libCGAL_Core.so.11
(0x00007f44b7764000)
        libboost_date_time-mt.so.1.53.0 =>
/usr/lib64/libboost_date_time-mt.so.1.53.0 (0x00007f44b7080000)
        libboost_thread-mt.so.1.53.0 =>
/usr/lib64/libboost_thread-mt.so.1.53.0 (0x00007f44b6e69000)
        libboost_system-mt.so.1.53.0 =>
/usr/lib64/libboost_system-mt.so.1.53.0 (0x00007f44b6c65000)
        libboost_serialization-mt.so.1.53.0 =>
/usr/lib64/libboost_serialization-mt.so.1.53.0 (0x00007f44b69f9000)

and there is no corresponding postgis_sfcgal-3.so I was expecting to see.


On my Ubuntu 20.04 that is using apt.postgresql.org  

ldd  /usr/lib/postgresql/12/lib/ postgis-3.so

shows no boost or SFCGAL dependencies, just has the stuff I'd expect to see
and there is a separate postgis_sfcgal-3.so

        linux-vdso.so.1 (0x00007ffd3b9ea000)
        libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f9c467d7000)
        libstdc++.so.6 => /lib/x86_64-linux-gnu/libstdc++.so.6
(0x00007f9c465f6000)
        libgeos_c.so.1 => /lib/x86_64-linux-gnu/libgeos_c.so.1
(0x00007f9c465b3000)
        libproj.so.15 => /lib/x86_64-linux-gnu/libproj.so.15
(0x00007f9c462c4000)
        libjson-c.so.4 => /lib/x86_64-linux-gnu/libjson-c.so.4
(0x00007f9c462b2000)
        libprotobuf-c.so.1 => /lib/x86_64-linux-gnu/libprotobuf-c.so.1
(0x00007f9c462a5000)
        libxml2.so.2 => /lib/x86_64-linux-gnu/libxml2.so.2
(0x00007f9c460eb000)
        libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1
(0x00007f9c460d0000)
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f9c45ede000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f9c46a6c000)
        libgeos-3.8.0.so => /lib/x86_64-linux-gnu/libgeos-3.8.0.so
(0x00007f9c45d15000)
        libsqlite3.so.0 => /lib/x86_64-linux-gnu/libsqlite3.so.0
(0x00007f9c45bec000)
        libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0
(0x00007f9c45bc9000)
        libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f9c45bc1000)
        libicuuc.so.66 => /lib/x86_64-linux-gnu/libicuuc.so.66
(0x00007f9c459db000)
        libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f9c459bf000)
        liblzma.so.5 => /lib/x86_64-linux-gnu/liblzma.so.5
(0x00007f9c45996000)


Thanks,
Regina