Bug 1008506

Summary:	Add postgis to latest postgresql SCL
Product:	Red Hat Software Collections	Reporter:	Honza Horak <hhorak>
Component:	distribution	Assignee:	Brian Gollaher <bgollahe>
Status:	CLOSED WONTFIX	QA Contact:
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	rh-postgresql95	CC:	admiller, andreas.luik, bandrade, bgollahe, bugzilla, caugello, cshereme, hgomes, hhorak, jbuchta, joboyer, jorton, kanderso, kwalker, mdekan, mmaslano, pkubat, praiskup, sople
Target Milestone:	---	Keywords:	FutureFeature
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2019-07-17 14:38:45 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Honza Horak 2013-09-16 13:48:32 UTC

Description of problem:
OpenShift asked for inclusion of postgis package into postgresql92 collection and we can expect other similar requirements in the future.

PostGIS adds support for geographic objects to the PostgreSQL object-relational
database. In effect, PostGIS "spatially enables" the PostgreSQL server,
allowing it to be used as a backend spatial database for geographic information
systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS
follows the OpenGIS "Simple Features Specification for SQL" and has been
certified as compliant with the "Types and Functions" profile.

If this is approved, then we'd need to include some more packages because of dependencies. Pure list of dependencies without deeper analysis if some requirement can be removed is here:

proj
geos
gdal
|- armadillo
|- cfitsio
|- CharLS
|- freexl
|- g2clib
|- hdf
|- hdf5
|- libgta
|- libspatialite
|- libwebp
|- netcdf
|- libdap
|- librx
|- gpsbabel
  |- shapelib

Comment 4 Honza Horak 2013-11-01 14:01:10 UTC

Just FTR, it was decided to not include postgis into RHSCL 1.1. The reason is that there are too many dependencies which can be limited by removing some of the features, but since we don't have specific customer requests, we don't know the use cases well enough.

Some more notes for the future.. The following list seems to be a *minimum* set (not what is currently used in Fedora) of packages that would need to be added into postgresql92 collection to have postgis successfully built:

 * proj
 * geos
 * gdal
 * libgeotiff
 * CharLS
 * g2clib-devel

If we would like to build gdal *exactly* as it is packaged in fedora, we'd end up with the following extra list of dependencies that are not in rhel:

 * cfitsio
 * hdf
 * hdf5
 * libdap
 * librx
 * netcdf
 * ogdi
 * armadillo
 * freexl
 * libgta
 * libspatialite
 * libwebp
 * gpsbabel
 * shapelib

Comment 11 Honza Horak 2016-02-04 15:42:19 UTC

*** Bug 1300650 has been marked as a duplicate of this bug. ***

Comment 16 Petr Kubat 2016-10-13 12:34:08 UTC

FYI: I have taken a look at the postgis package and its dependencies that are missing from RHEL7 in a bit more detail:

Required dependencies:

    geos
    proj
    gdal
    libgeotiff - Needed for GeoTIFF format
    g2clib - Needed for GRIB format

Optional dependencies:

    CharLS - JPEG-LS driver
    cfitsio - FITS data format
    hdf + hdf5 - HDF and other data formats
    libdap - OPeNDAP support
    libgta - GTA format
    openjpeg2 - JPEG2000 driver
    netcdf -  NetCDF data format
    freexl - Excel file extraction
    armadillo - Linear algebra library for faster computation
    libkml - Google driver for KML

Not needed dependencies (for PostGIS):

    gpsbabel - used for gps format conversion, don't think PostGIS uses this
    libspatialite - Spatialite (SQLite)
    ogdi - From GDAL >= 1.5.0, there should be little reason to use the OGDI raster bridge
    librx - POSIX regexp functions, have not found out what it is used for so far

Comment 27 Joe Orton 2019-03-14 11:02:42 UTC

Red Hat does not currently plan to provide any further changes to this collection in a Red Hat Software Collections update release.

This software collection is nearing the retirement date (May 2019) after which customers are encouraged to upgrade to a later release.

Please contact Red Hat Support if you have further questions, or refer to the support lifecycle page for more information. https://access.redhat.com/support/policy/updates/rhscl/

Comment 29 Joe Orton 2019-06-14 13:06:17 UTC

In accordance with the Red Hat Software Collections Product Life Cycle, the support period for this collection has ended.

New bug fix, enhancement, and security errata updates, as well as technical support services will no longer be made available for this collection.

Customers are encouraged to upgrade to a later release.

Please contact Red Hat Support if you have further questions, or refer to the support lifecycle page for more information. https://access.redhat.com/support/policy/updates/rhscl/

Comment 34 Joe Orton 2019-07-17 14:38:45 UTC

This request was evaluated by Red Hat Engineering for inclusion in a
future update to Red Hat Enterprise Linux.  Red Hat does not plan to
provide this feature in Red Hat Software Collections.

With the goal of minimizing risk of change for deployed systems, and
in response to customer and partner requirements, Red Hat takes a
conservative approach when evaluating enhancements for inclusion in
maintenance updates for currently deployed products.