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
_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users

Reply via email to