Date: Mon, 13 Nov 2023 07:29:44 +0000
To: Regina Obe <lr@pcorp.us>
From: Simon Connah <simon.n.connah@protonmail.com>
Cc: pgsql-pkg-yum@lists.postgresql.org
Subject: RE: PostgreSQL 16 and PostGIS
Message-ID: 
 <yJV8oUaz1p3nFXZkaAvyrsJMK7_79zErff72KkwetzqVWPgRf-g5BBvXyPOXXqgx50YVucK1RDsNPh-xqYeMiMq0nkohTcHVaXmDy7OEOoc=@protonmail.com>
In-Reply-To: <001401da1600$76249150$626db3f0$@pcorp.us>
References: 
 <brbt4AcTOFGzm7f8pSWscTjSev0eH_9sbFdfuoiMk0fdgmTFWrnBK1RnbbcSv6Ur2IjEx_NSRfF9lgYPJ8xW9J3-nP4ZMv1HOV2nA28xwk8=@protonmail.com>
 <001401da1600$76249150$626db3f0$@pcorp.us>
Feedback-ID: 24074989:user:proton
MIME-Version: 1.0
Content-Type: multipart/signed; protocol="application/pgp-signature";
 micalg=pgp-sha512;
 boundary="------e34ea4f775014d5e5a2134472a2e6e8bb0d882532da239a79353c0c053ddf719";
 charset=utf-8
Archived-At: 
 <https://www.postgresql.org/message-id/yJV8oUaz1p3nFXZkaAvyrsJMK7_79zErff72KkwetzqVWPgRf-g5BBvXyPOXXqgx50YVucK1RDsNPh-xqYeMiMq0nkohTcHVaXmDy7OEOoc%3D%40protonmail.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------e34ea4f775014d5e5a2134472a2e6e8bb0d882532da239a79353c0c053ddf719
Content-Type: multipart/mixed;boundary=---------------------914e6aaf8f0240388571dac00ac4750e

-----------------------914e6aaf8f0240388571dac00ac4750e
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;charset=utf-8


> > 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@139-162-197-226 simon]# dnf update Last metadata expiration chec=
k:
> > 1:11:27 ago on Mon 13 Nov 2023 05:02:27 AM UTC.
> > Dependencies resolved.
> > Nothing to do.
> > Complete!
> > [root@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 >=3D 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 '--nobes=
t' 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.
-----------------------914e6aaf8f0240388571dac00ac4750e--

--------e34ea4f775014d5e5a2134472a2e6e8bb0d882532da239a79353c0c053ddf719
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: ProtonMail

wnUEARYKACcFgmVR0E8JkFrvKC74ta6lFiEEXOYF9uqFRn4815bYWu8oLvi1
rqUAAKA5AP0SUwPuarm3NjpHU1dpOYPMglAtLpTXsZ3hZZqs6CQz/QD/exEw
BY8MUdjIz8ZrEm7IfJYFTlMwA84RhCy2gr+YHAM=
=WiTi
-----END PGP SIGNATURE-----


--------e34ea4f775014d5e5a2134472a2e6e8bb0d882532da239a79353c0c053ddf719--