Message-ID: <9966f2577a74a4f8490867821e27b7cb8d33a857.camel@gunduz.org>
Subject: Re: postgresql13-devel vs libpq-devel
From: Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= <devrim@gunduz.org>
To: Marcin Cieslak <saper@saper.info>, pgsql-pkg-yum@lists.postgresql.org
Date: Tue, 15 Apr 2025 15:52:22 +0300
In-Reply-To: <11n1s5sp-248p-ps21-700p-7pnp7rnr9992@fncre.vasb>
References: <11n1s5sp-248p-ps21-700p-7pnp7rnr9992@fncre.vasb>
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-sha256";
	protocol="application/pgp-signature"; boundary="=-pu66a6aakqf6iUIiPJMy"
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/9966f2577a74a4f8490867821e27b7cb8d33a857.camel%40gunduz.org>
Precedence: bulk


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

Hi Marcin,

On Mon, 2025-04-14 at 16:24 +0000, Marcin Cieslak wrote:
>=20

> The RHEL 9 machine I have has postgresql13, -libs, -server and -devel
> installed from the PGDG repository (all at the 13.20-1PGDG revision).
>=20
> Today I have tried to rebuild a package provided by Red Hat (rsyslog)
> and it has a build time dependency on libpq-devel [1].
>=20
> dnf --enablerepo pgdg-common --enablerepo pgdg13 install libpq-devel
>=20
> does nothing since "postgresql13-devel" already "obsoletes" libpq-deve
> but it does not full replace it (it does not "provide" libpq-devel).

That's because I never thought of replacing libpq-devel (not that I did
not want to, I missed that)=20

>=20
> This is kind of expected, I could install postgresql13-devel,
> postgresdql14-devel
> up to the 18 if I really like in parallel. I can't do this with libpq-
> devel.
>=20
> However, the RPM packages obviously want to have it Red Hat way, no
> the Postgres way.
>=20
> Today, as it happens, RHEL 9 has 13.20 in their base, and I have
> 13.20-1PGDG
> installed, but this is just a nice coincidene - I have simply done
>=20
> dnf erase --noautoremove postgresql13-devel
> dbf install libpq-devel
>=20
> Is there any elegant solution to this problem? For example, is there
> any clean way to say "please using my postgresql13-devel and instead
> of libpq-devel?"
> to rpmbuild? That would require telling PATH and pkgconf to go
> somewhere else...

There are two options in here:

1. Edit the spec file and replace libpq-devel BR with libpq5-devel.

2. (As you suggested): Export PATH like this (and line 45):

https://git.postgresql.org/gitweb/?p=3Dpgrpms.git;a=3Dblob;f=3Drpm/redhat/m=
ain/non-common/plxslt/main/plxslt.spec#l40

In your case replace %{pginstdir} with /usr/pgsql-13

I'd do the latter (see below)


> Or maybe postgresql13-devel and libpq-devel should get along with each
> other?
> I think postgresql13-libs and RHEL's libpq do, and both provide
> "libpq.so.5()".

So, history first: After introducing multiple version installation about
15 years ago (I know, I know...) my plan was to wait until 8.4 is EOLed
so that I could build a common libpq/libpq-devel package in our repo. It
never happened as I did not want to break any builds. But that is now
past.

In the last couple weeks I made a few attempts to build a libpq5-devel
which provides all pieces of a postgresql$latestMajorVersion-devel . It
is still WIP. Once that is done I can *also* obsolete libpq-devel.

-HTH

Regards,
--=20
Devrim G=C3=BCnd=C3=BCz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR

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

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

iQJGBAABCAAwFiEEH8GKHNUOKtDEiyD22MM9/pLPbrUFAmf+VocSHGRldnJpbUBn
dW5kdXoub3JnAAoJENjDPf6Sz261x50P/0v6ZpKUFEAhao9LhihmlbPeLYo8w+Mh
2Jv/HV17z3gf3xcJiccrSf3wEUqIHaNh4EeHUhYgT9V5eIcX5nEVhCRqCQhr6v4h
NYv889F2vnzI8ka+0Lt292GKx9RYxCFGGOMTmZRDSmS6sWiXDCoJodyz2OQ+USFM
eKe5yu+a468EWIQ9d0U8ongwAtEy9CNEDU+VdCL2R2xHqy88bEtsrshTsznmbLCN
VO7cdlGXZD8kyKCKn8MJkJFFeDX/PbqiCI1KUZ5zzq/sTFoHAjr16QDU9Yd3zIJU
n0BMo6X99QXrJAdioRA1Qd56JTmlgwGk2+bBDTvOmDg8fClpx38riCthtkVtzYpj
rdLmUVeTaKffs+AiRHRxr+tLv2Lu2iW9RK3TVdKpbbUzMxEevK1jerFVhCIhUWqM
2kR8YcnGkgUZ0gO0YXy8aHzwP8z507ZIu0k7tMkFkwcJEnp3e/mxrXHPMJmgKCeg
v4fW18TXRqDUKJps8Mwz7SVqn42rgYuNqy5d6y8dwF+I7+MMX+PdJJxAxfDapcP2
tqlXuvgP8wTvC/5Ur2R/zhxdQZZWJ3M3wYMgjUiiaSXekizuPo6egRleGCb1Ij0h
WYkEONJCScNwDIv9Lms9F4zkCZBax/NL581MUIrH8dUKWc2E8R9ex8/usiVSjxgi
FFM8j9YlrJ8s
=RR3U
-----END PGP SIGNATURE-----

--=-pu66a6aakqf6iUIiPJMy--