Message-ID: <6950f22b188e6d8e7c8ec889844d656ce962ddce.camel@gunduz.org>
Subject: Re: RHEL8+9 libpcre2 dependencies in postgis packages
From: Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= <devrim@gunduz.org>
To: "Lorenz, Christopher" <Christopher.Lorenz@ZIT-BB.Brandenburg.de>,
 "pgsql-pkg-yum@lists.postgresql.org"
	 <pgsql-pkg-yum@lists.postgresql.org>
Date: Wed, 12 Nov 2025 15:27:34 +0300
In-Reply-To: <fc8e323142484d98b5d1720e0811ce9c@ZIT-BB.Brandenburg.de>
References: <fc8e323142484d98b5d1720e0811ce9c@ZIT-BB.Brandenburg.de>
Autocrypt: addr=devrim@gunduz.org; prefer-encrypt=mutual;
 keydata=mQINBFN+TjkBEAC6pudhV1V54kHPe91nr6Erz6VuG93VKfcHOHN86yET35s8ytey7f//m
 93mW0X6LJUMbY+Z0BztU4EauGAhYRSFzpBWUVBCxaaSyB+l0FR6WtH/Lv6Sxql0GLs6Uhxsk2v3jJ
 tMtk+hFAW2TJInW0ab1xxwTiiHFmSnJOBEK7IMlOOu5kfOAILgGOgiyMUPsDf5iTIJ35iX9hqFvmz
 MueFVwAExTeTkKCRXvuGXrO28Bbesy6h4GbJe1bUaTwTMEBn90oQD20UUKI9Lvo46c1SkqF1nOSoQ
 A3A2eBjWACq68DQ9Q8TbtkBlL8QKftrFz3SL0jth9ZpxyYfm+jiZ5LEAd717YM7qjvH5Yq0juZO3U
 jz2L9RVgyIF1lTQ33fQEuGn797n7LxdaQSdOYK88yrpABic6fJs6rxGy86HcNVHJQCfxgu+uU4eG9
 /wzBKllXreabD2JJXIRjqvhJTXd7JWaF6TZUEUM0SH2GlA6I2G2vGSyRoe0/jaqUIDGm5drzFGkrK
 7CwhWzLqxSBlVkCelhOVfDuyit3ypwPhsztTOgZ9w3iwnAPZWuqXbys2Z26H9hQb5eG7xlkCZwlSr
 mD8mUdHlU5DP84VPIXX6mGCh0I4EJ4ur61CNESpv86BKfGUpbl/3x9XSmcWfvdxB4JnrjHBm9aDIQ
 ZzukEJGdiGBpQARAQABtCNEZXZyaW0gR8O8bmTDvHogPGRldnJpbUBndW5kdXoub3JnPokCOQQTAQ
 IAIwUCU35OOQIbAwcLCQgHAwIBBhUIAgkKCwQWAgMBAh4BAheAAAoJENjDPf6Sz261pAgP/j4OJd8
 EfBLcdkeYyWKNVV3xN6KGF5tTo5iLjjIBmxmj7403DoigD4qfXY8UQ1hG1e0vTe+zaBuL+fMmn3Rg
 SAcUcjNUjVwcOeGFIMO0uMDX4xnMeAahjuc+2EKBFBW0UY21aH6BdmM98GkU/gyBpaMt/MC+5Xgsj
 1koqlA9vCj1bnDXVNP7w/MPhVsEGbhkBZFB/vwVDVJ0J1U4vA1pr2ggUGOOv0kXu7r7B7nGQgcxN8
 qh8QBgfP4ePzbubdA3oGY3PTmRjWWDAzA7HpnKD9pPiAFxvhmnUVcOCdTCo9mNaJc+kRXP7yGbsQa
 rOWvLMtCvKa0DjFJ6SDY45h3g1XF+Xp/ZMZLbJ7xNc3zEVnBZc0AIvGL+IlQbo9trPdJvjdrFATio
 UV/cLxug1p4kl8JB6YMvToiKFmMlpQv2wcKK63bm01lDjU93sAy8oZpeKYlOYlN9D0WmyhJbFTlTl
 IJhMX0aY/xfxUaMYJC5DxV+9s18uviqGWDb2zQR3i3qUbfzV27yHnKo194rUblZ128CzAjs32NerE
 CLJjKEpc2Ci14fJZz6c6P0J5JTONBKhAzygQi/l97RGBqsLiniJIsTUjGH+hEr7hTnhEg/ZOQSs32
 h9vVjhQB7WJ9Xg9A3Frw5mD+W3YkMMM4bFryLTM5p7E1iwGlx+XeM8UMzhtYt
Content-Type: multipart/signed; micalg="pgp-sha512";
	protocol="application/pgp-signature"; boundary="=-h2HNKzmQzDAN5kdqyMRl"
User-Agent: Evolution 3.58.1 (3.58.1-1.fc43) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/6950f22b188e6d8e7c8ec889844d656ce962ddce.camel%40gunduz.org>
Precedence: bulk


--=-h2HNKzmQzDAN5kdqyMRl
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

On Wed, 2025-11-12 at 07:30 +0000, Lorenz, Christopher wrote:
> on last update we got some errors updating postgis in RHEL8:
>=20
> Problem 1: cannot install the best update candidate for package
> postgis31_13-3.1.12-10PGDG.rhel8.x86_64
> - nothing provides libpcre2-8-0 needed by postgis31_13-3.1.12-
> 13PGDG.rhel8.x86_64 from PostgreSQL_PostgreSQL13_-_RHEL_8_x86_64
> Problem 2: cannot install the best update candidate for package
> postgis31_14-3.1.12-10PGDG.rhel8.x86_64
> - nothing provides libpcre2-8-0 needed by postgis31_14-3.1.12-
> 13PGDG.rhel8.x86_64 from PostgreSQL_PostgreSQL14_-_RHEL_8_x86_64
>=20

Ouch :(

> I've found that the dependencies changed from pcre to libpcre2-8-0:
>=20
> $ rpm -qp /tmp/postgis31_13-3.1.12-13PGDG.rhel8.x86_64.rpm --requires
> | grep pcre
> libpcre.so.1()(64bit)
> libpcre2-8-0
> $ rpm -qp /tmp/postgis31_13-3.1.12-10PGDG.rhel8.x86_64.rpm --requires
> | grep pcre
> libpcre.so.1()(64bit)
> pcre
>=20
> The libraries libpcre2 are provided by pcre2 on RHEL8+9:
>=20
> $ rpm -qf /usr/lib64/libpcre2-8.so.0
> pcre2-10.32-3.el8_6.x86_64
> $ rpm -qf /usr/lib64/libpcre.so.1
> pcre-8.42-6.el8.x86_64
>=20
> I've found the commit for postgis 3.1:
> https://git.postgresql.org/gitweb/?p=3Dpgrpms.git;a=3Dcommitdiff;h=3Da2e3=
9ff2a23b5c925ff0fb08340c6a7f85313c29
> As I can see you use pcre2 only from RHEL10 upwards, but RHEL8 and
> RHEL9 also provides the library with package pcre2 .

Thanks for the report!

That is right. Pushed fixes to git repository and also building the RPMs
now. I'll push them along with tomorrow's minor release updates.

Regards,
--=20
Devrim G=C3=BCnd=C3=BCz
Open Source Solution Architect, PostgreSQL Major Contributor
BlueSky: @devrim.gunduz.org , @gunduz.org

--=-h2HNKzmQzDAN5kdqyMRl
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----

iQJGBAABCgAwFiEEH8GKHNUOKtDEiyD22MM9/pLPbrUFAmkUfTYSHGRldnJpbUBn
dW5kdXoub3JnAAoJENjDPf6Sz261eFUP/R+hth4V1rVQB0XLxOOdTW9ftzhQCugA
S3o1s28DZsqCVghAL4iL6/Fg7hoF2nIwvauXSydMfwLNboIEYjFD4E/0D2qDpcCf
TtnoFO2HJDlQgJVLWhQAVbIf7gVIcAWnEsPmL1AAtdy1JAizsZF4s4AtQZ9Gbd9P
Rv6nhnbJSUz4NVKlNeT8vn851Gceiiz45uNoFQRkH9VgtYdXQl+ApHdPu+LRTCJD
hX8weNWPbnpYZy9ImkfqMeN0l9hIYJAmSfdc4Y+VySERBasZdnTyHv9n2YDgttBG
yhUuXKkRos0rAZGiTEgXaoX6+W/5LL7z/ayJzpyy+Kis+3Z4Nt+8Xs56CEtFDo7y
uDDkxsVdniQkGr/hsUJtBCyXa4Y8tMUV5nHMDJH/yuQxw8LLUGrD30FRUiZ0t/n9
NM4jB2re+/hfpPIEDL3Q0+0+4U5PMBZ29SHrjQVmuzqzxvrL+vgsuFM8/X4th0kD
S79VWLJ/onh0iIQwaDssGMYur/K/yT0wDUSe/itTlg1N5shrx1u8KEDlBSUYTc/T
Sv6qaX12y2p+3KtK7HNSyp9TKLTi2aCvgNIV0B9EGc2acsysl8A7FLkIgTsyqMnn
Tmh1H8fwnxjMEK9o4gHqXsb2sSyud976habU/Twyf55EL09BL+mNoYEYI9YRoxa1
A24L6e8CCA6V
=uv9N
-----END PGP SIGNATURE-----

--=-h2HNKzmQzDAN5kdqyMRl--