UNCLASSIFIED - NO CUI

Add postgis extension installation to image

Feature description

Install the PostGIS library packages from the matching PostgreSQL repository on the managed image so the extensions are ready to use out of the box.

Use cases

It would be extremely helpful to already have the postgis libraries packages that match the PostgreSQL version upstream (included in their repositories) installed on the managed image for Postgres and ready to enable the extensions out of the box. Many projects using PostgreSQL images are utilizing these extensions.

Benefits

See above

Requirements

Install postgis25_11 or postgis30_11 package from matching postgres repository when creating image. It looks like a lot of the RPMs currently are pulled directly and installed locally from /tmp. This could still be done, would just need to collect the rest of them and dependencies.

There are a couple dependencies that exist only in EPEL to my knowledge, but I think that's a couple packages only.

Links / references

https://postgis.net/install/

Definition of Done

  • Feature has been implemented

/cc @ironbank-notifications/feature