[postgis-users] Slim RPM for PostGIS

[peter.borissow at kartographia.com]

Dear PostGIS Community,
    Apologies in advance if this is a duplicate message. I tried emailing a few days ago but I don't know if it went through.
 
I have been tasked to put together an offline installer for a web app I built that uses PostgreSQL+PostGIS under the hood. The target OS is RHEL 8. I have been working with PostGIS on Ubuntu for >10 years but I never had to put together an offline installer before. sudo apt-get is all I ever needed ;-)

Anyway, I started pulling together all the RPMs I need for RHEL and everything was been going well up until I starting working on the PostGIS piece. I tried installing postgis31_13-3.1.4-1.rhel8.x86_64.rpm from here:
 
[ https://download.postgresql.org/pub/repos/yum/13/redhat/rhel-8-x86_64/ ]( https://download.postgresql.org/pub/repos/yum/13/redhat/rhel-8-x86_64/ )
 
This particular RPM has dozens of dependencies which in return have their own dependencies so the install package is turning out to be quite big and a real pain to put together. Initial RPM error is below.

For my application, I only use PostGIS for spatial queries (e.g. ST_Intersects), some basic transformations (e.g. ST_Buffer, ST_Union, ST_Centroid), reprojection to/from 4326<->900913 using ST_Transform, a few measurement functions (e.g. ST_Distance, ST_Area), and reading/writing WKT and EWKB (e.g. ST_GeomFromText).
 
I don't need GDAL for example and the dozens of libs that it needs for reading/writing data. I don't need Protobuf, Xerces, GeoTiff, HDF, etc. I don't know if I need need SFCGAL but that library has dependencies on CGAL which in turn have dependencies on things like QT which I definitely don't need.
 
So I switched gears and started looking at building my own RPM with my own build of PostGIS with less dependencies but I'm a little out of my depth.

In short, I was wondering if someone can help me put together a "slim" RPM for RHEL 8? Or maybe point me to one that exists already?

This is for a commercial customer and I would gladly trade the day or two of my time hunting down RPMs in exchange for a PostGIS pro that can compile a simple RPM for me. I would freely share the output of this effort under any open source license.

Thanks in advance,
Peter


PS. Here's the output of my first install attempt using the PostGIS RPM. I've cut some of this down since by finding some of the RPMs and I'll keep plugging away until I got them all...


rpm -ivh postgis31_13-3.1.4-1.rhel8.x86_64.rpm
warning: postgis31_13-3.1.4-1.rhel8.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
error: Failed dependencies:
        SFCGAL is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        gdal33-libs >= 3.3.1 is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        geos39 >= 3.9.1 is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        hdf5 is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        libSFCGAL.so.1()(64bit) is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        libgdal.so.29()(64bit) is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        libgeos_c.so.1()(64bit) is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        libgeotiff16 is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        libproj.so.22()(64bit) is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        libprotobuf-c.so.1()(64bit) is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        libprotobuf-c.so.1(LIBPROTOBUF_C_1.0.0)(64bit) is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        libtiff.so.5()(64bit) is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        proj81 >= 8.1.0 is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        protobuf-c >= 1.1.0 is needed by postgis31_13-3.1.4-1.rhel8.x86_64
        xerces-c is needed by postgis31_13-3.1.4-1.rhel8.x86_64
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20211027/b6d6736f/attachment.html>