[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: [postgis-users] Slim RPM for PostGIS
From: "peter.borissow () kartographia ! com" <peter ! borissow () kartographia ! com>
Date: 2021-10-27 21:12:32
Message-ID: 1635369152.34644652 () apps ! rackspace ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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
[Attachment #5 (text/html)]
<font face="arial" size="2"><p style="margin:0;padding:0;font-family: arial; \
font-size: 10pt; overflow-wrap: break-word;">Dear PostGIS Community,<br \
/> 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.</p> <p \
style="margin:0;padding:0;font-family: arial; font-size: 10pt; overflow-wrap: \
break-word;"> </p> <p style="margin:0;padding:0;font-family: arial; font-size: \
10pt; overflow-wrap: break-word;">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 ;-)<br /><br />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:</p> <p \
style="margin:0;padding:0;font-family: arial; font-size: 10pt; overflow-wrap: \
break-word;"> </p> <p style="margin:0;padding:0;font-family: arial; font-size: \
10pt; overflow-wrap: break-word;"><a \
href="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/</a></p>
<p style="margin:0;padding:0;font-family: arial; font-size: 10pt; overflow-wrap: \
break-word;"> </p> <p style="margin:0;padding:0;font-family: arial; font-size: \
10pt; overflow-wrap: break-word;">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.<br /><br \
/>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).</p> \
<p style="margin:0;padding:0;font-family: arial; font-size: 10pt; overflow-wrap: \
break-word;"> </p> <p style="margin:0;padding:0;font-family: arial; font-size: \
10pt; overflow-wrap: break-word;">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.</p> <p style="margin:0;padding:0;font-family: arial; font-size: 10pt; \
overflow-wrap: break-word;"> </p> <p style="margin:0;padding:0;font-family: \
arial; font-size: 10pt; overflow-wrap: break-word;">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.</p> <p style="margin:0;padding:0;font-family: \
arial; font-size: 10pt; overflow-wrap: break-word;"><br />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?<br /><br />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.<br /><br />Thanks in advance,<br />Peter<br /><br /><br \
/>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...<br /><br /><br />rpm -ivh postgis31_13-3.1.4-1.rhel8.x86_64.rpm<br \
/>warning: postgis31_13-3.1.4-1.rhel8.x86_64.rpm: Header V4 DSA/SHA1 Signature, key \
ID 442df0f8: NOKEY<br />error: Failed dependencies:<br \
/> SFCGAL is needed by \
postgis31_13-3.1.4-1.rhel8.x86_64<br /> \
gdal33-libs >= 3.3.1 is needed by postgis31_13-3.1.4-1.rhel8.x86_64<br \
/> geos39 >= 3.9.1 is needed by \
postgis31_13-3.1.4-1.rhel8.x86_64<br /> \
hdf5 is needed by postgis31_13-3.1.4-1.rhel8.x86_64<br \
/> libSFCGAL.so.1()(64bit) is needed by \
postgis31_13-3.1.4-1.rhel8.x86_64<br /> \
libgdal.so.29()(64bit) is needed by postgis31_13-3.1.4-1.rhel8.x86_64<br \
/> libgeos_c.so.1()(64bit) is needed by \
postgis31_13-3.1.4-1.rhel8.x86_64<br /> \
libgeotiff16 is needed by postgis31_13-3.1.4-1.rhel8.x86_64<br \
/> libproj.so.22()(64bit) is needed by \
postgis31_13-3.1.4-1.rhel8.x86_64<br /> \
libprotobuf-c.so.1()(64bit) is needed by postgis31_13-3.1.4-1.rhel8.x86_64<br \
/> \
libprotobuf-c.so.1(LIBPROTOBUF_C_1.0.0)(64bit) is needed by \
postgis31_13-3.1.4-1.rhel8.x86_64<br /> \
libtiff.so.5()(64bit) is needed by postgis31_13-3.1.4-1.rhel8.x86_64<br \
/> proj81 >= 8.1.0 is needed by \
postgis31_13-3.1.4-1.rhel8.x86_64<br /> \
protobuf-c >= 1.1.0 is needed by postgis31_13-3.1.4-1.rhel8.x86_64<br \
/> xerces-c is needed by \
postgis31_13-3.1.4-1.rhel8.x86_64</p></font>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic