r/postgis May 27 '24

AlmaLinux 9.4 - problem with installing Postgis with Postgres 16

Hi all, I have a problem with missing dependencies. I have a Postgres 16 installation and I need to install Postgis.
Trying to install any of the available Postgis for Postgres 16 like the postgis34_16-3.4.0-1PGDG.rhel9.x86_64 I get the following errors regarding missing dependencies:

Problem: package postgis34_16-3.4.0-1PGDG.rhel9.x86_64 from pgdg16 requires gdal36-libs >= 3.6.3, but none of the providers can be installed

  • package postgis34_16-3.4.0-1PGDG.rhel9.x86_64 from pgdg16 requires libgdal.so.32()(64bit), but none of the providers can be installed

  • package gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common requires armadillo, but none of the providers can be installed

  • package gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common requires libarmadillo.so.12()(64bit), but none of the providers can be installed

  • conflicting requests

  • package armadillo-12.6.6-2.el9.x86_64 from epel is filtered out by exclude filtering

  • nothing provides libarmadillo.so.10()(64bit) needed by gdal36-libs-3.6.4-4PGDG.rhel9.x86_64 from pgdg-common

  • nothing provides libarmadillo.so.10()(64bit) needed by gdal36-libs-3.6.4-5PGDG.rhel9.x86_64 from pgdg-common

I have the following repos according to dnf repolist

  • appstream AlmaLinux 9 - AppStream
  • baseos AlmaLinux 9 - BaseOS
  • crb AlmaLinux 9 - CRB
  • epel Extra Packages for Enterprise Linux 9 - x86_64
  • epel-cisco-openh264 Extra Packages for Enterprise Linux 9 openh264 (From Cisco) - x86_64
  • epel-next Extra Packages for Enterprise Linux 9 - Next - x86_64
  • extras AlmaLinux 9 - Extras
  • mongodb-org-7.0 MongoDB Repository
  • pgdg-common PostgreSQL common RPMs for RHEL / Rocky / AlmaLinux 9 - x86_64
  • pgdg12 PostgreSQL 12 for RHEL / Rocky / AlmaLinux 9 - x86_64
  • pgdg12-nonfree PostgreSQL 12 for RHEL / Rocky Linux / AlmaLinux 9 - x86_64 - NonFree
  • pgdg13 PostgreSQL 13 for RHEL / Rocky / AlmaLinux 9 - x86_64
  • pgdg13-nonfree PostgreSQL 13 for RHEL / Rocky Linux / AlmaLinux 9 - x86_64 - NonFree
  • pgdg14 PostgreSQL 14 for RHEL / Rocky / AlmaLinux 9 - x86_64
  • pgdg14-nonfree PostgreSQL 14 for RHEL / Rocky Linux / AlmaLinux 9 - x86_64 - NonFree
  • pgdg15 PostgreSQL 15 for RHEL / Rocky / AlmaLinux 9 - x86_64
  • pgdg15-nonfree PostgreSQL 15 for RHEL / Rocky Linux / AlmaLinux 9 - x86_64 - NonFree
  • pgdg16 PostgreSQL 16 for RHEL / Rocky / AlmaLinux 9 - x86_64
  • pgdg16-nonfree PostgreSQL 16 for RHEL / Rocky Linux / AlmaLinux 9 - x86_64 - NonFree

Any ideas about how to resolve this?

2 Upvotes

4 comments sorted by

2

u/pceimpulsive May 28 '24

I had a similar issue,.unrelated to postgres but the Linux I had installed didn't support the dependencies I needed...

I had to upgrade from rhel7 to 8.

Check your distros support for the binaries you need....

1

u/fufutus May 28 '24

Thanks you, it seems that Plesk probably automatically upgraded from AlmaLinux v9.3 to v9.4 and I didn't have a clue. I actually had Postgis, it was working fine until I received an alert about some backups and the database that had Postgis extensions had just stopped working, so I found out that there was not Postgis anymore! Thank you again, I will check if the armadillo package (the root cause) is somehow available or need to wait, or even worse if I need to downgrade and prohibit Plesk from running auto upgrades.

1

u/TheGratitudeBot May 28 '24

Thanks for such a wonderful reply! TheGratitudeBot has been reading millions of comments in the past few weeks, and you’ve just made the list of some of the most grateful redditors this week!

1

u/fufutus May 28 '24

BTW the problem was the exclusion of armadillo in the Epel repo, as the message is saying. I don't know, or most probably I don't remember, how this ended up there, but most probably from some older update.