RE: PostgreSQL 16 and PostGIS

From: Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com>
To: Regina Obe <lr(at)pcorp(dot)us>
Cc: pgsql-pkg-yum(at)lists(dot)postgresql(dot)org
Subject: RE: PostgreSQL 16 and PostGIS
Date: 2023-11-13 07:29:44
Message-ID: yJV8oUaz1p3nFXZkaAvyrsJMK7_79zErff72KkwetzqVWPgRf-g5BBvXyPOXXqgx50YVucK1RDsNPh-xqYeMiMq0nkohTcHVaXmDy7OEOoc=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-yum


> > Hi,
>

> > I originally posted in the PostgreSQL novice list that I had installed PostgreSQL
> > 16 on Rocky Linux 9 using this method:
> >

> > https://www.postgresql.org/download/linux/redhat/
> >

> > and it works perfectly. But when I try and install PostGIS I ended up getting this
> > error:
> >

> > [root(at)139-162-197-226 simon]# dnf update Last metadata expiration check:
> > 1:11:27 ago on Mon 13 Nov 2023 05:02:27 AM UTC.
> > Dependencies resolved.
> > Nothing to do.
> > Complete!
> > [root(at)139-162-197-226 simon]# dnf install postgis34_16 Last metadata
> > expiration check: 1:11:40 ago on Mon 13 Nov 2023 05:02:27 AM UTC.
> > Error:
> > Problem: package postgis34_16-3.4.0-1PGDG.rhel9.x86_64 requires gdal36-
> > libs >= 3.6.3, but none of the providers can be installed
> > - package postgis34_16-3.4.0-1PGDG.rhel9.x86_64 requires
> > libgdal.so.32()(64bit), but none of the providers can be installed
> > - conflicting requests
> > - nothing provides libqhull_r.so.7()(64bit) needed by gdal36-libs-3.6.4-
> > 4PGDG.rhel9.x86_64
> > - nothing provides libqhull_r.so.7()(64bit) needed by gdal36-libs-3.6.4-
> > 5PGDG.rhel9.x86_64
> > (try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use
> > not only best candidate packages)
> >

> > Is there any fix to this at all?
> >

> > Thank you.
> >

> > Simon.
>

>

> I think you might be missing the
>

> crb enable
>

> step that Devrim mentioned in an email thread.
>

> FWIW, I've updated the Yum instructions on postgis.net t o include that.
>

> https://postgis.net/documentation/getting_started/install_red_hat/
>

> Let me know if all that works for you or if I missed anything.
> Those worked for me, but I was testing with Rocky8
>

Hi,

I got it installed but had to change a command to get it to work.

I used the following:

dnf -y install epel-release
dnf config-manager --enable crb
crb enable
dnf -y install postgis34_16
systemctl restart postgresql-16

Simon.

In response to

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message David PEYRIERES 2023-11-24 15:00:48 Error install V16.1.4 on Rocky Linux 8.8
Previous Message Regina Obe 2023-11-13 07:10:19 RE: PostgreSQL 16 and PostGIS