Message-ID: <f679031dc1d2672101a72d41d48735a96f08c8e4.camel@gunduz.org>
Subject: Re: Heads up: Barman, Patroni, psycopg and Python 3.12
From: Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= <devrim@gunduz.org>
To: PostgreSQL RPM Packaging <pgsql-pkg-yum@lists.postgresql.org>
Date: Tue, 20 May 2025 16:44:26 +0300
In-Reply-To: <c3471866f1291b14ca6399f3f573dc98d17eb051.camel@gunduz.org>
References: <c3471866f1291b14ca6399f3f573dc98d17eb051.camel@gunduz.org>
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="=-LB0yN4K6ik+4Z8cxJg0N"
User-Agent: Evolution 3.56.1 (3.56.1-1.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/f679031dc1d2672101a72d41d48735a96f08c8e4.camel%40gunduz.org>
Precedence: bulk


--=-LB0yN4K6ik+4Z8cxJg0N
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

This is now completed except RHEL 9 - aarch64 (fat fingers on that
platform, so will work on that tomorrow).

https://github.com/pgdg-packaging/pgdg-rpms/issues/16

I had to introduce new packages for RHEL 8 and 9. Please note that I had
to use Python 3.11 on SLES 15 to use more packages in their repo.

Currently we use Python 3.13 on Fedora, Python 3.12 on RHEL 10, 9 and 8
and Python 3.11 on SLES 15.

I'd like to thank Seda Yavuz for testing Patroni packages extensively.=20

Still if you see any issues, please report it to us:

https://github.com/pgdg-packaging/pgdg-rpms/issues/new

Regards, Devrim

On Tue, 2025-05-13 at 16:30 +0300, Devrim G=C3=BCnd=C3=BCz wrote:
>=20
> Hi,
>=20
> I've been getting lots of complaints about the Python version that we
> use for Barman, Patroni and psycopg on RHEL 8 (3.6.8) as security
> scanners show red flag each time. Something for 3.9 (RHEL 9) will also
> come up this year. Also due to a few spec file tweaks in some Python
> related packages, I have to do a few manual work for barman RHEL 8
> builds (like removing all Python versions except 3.6.8 and then
> reinstall newer versions because of pyproject macros), which is not
> sustainable. See:
> https://github.com/pgdg-packaging/pgdg-rpms/issues/5=C2=A0
>=20
> Fedora 41 and 42 has 3.13 and RHEL 10 has 3.12. Fortunately both RHEL
> 8
> and RHEL 9 also have 3.12 in their repos which is safe for about 3
> more
> years.
>=20
> So the plan is using Python 3.12 for RHEL 8 and 9 and using whatever
> available for Fedora and RHEL 10.
>=20
> A major problem is psycopg3. My intention is to build a separate
> python312-psycopg3 package so that it won't break current
> installations.
> There are some missing Python 3.12 dependencies for Barman on RHEL 8
> and
> 9, and I will introduce new packages to solve that problem. Patroni is
> the easiest piece in here.
>=20
> Barring any objections, I plan to work on this soon.
>=20
> Regards,

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

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

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

iQJGBAABCgAwFiEEH8GKHNUOKtDEiyD22MM9/pLPbrUFAmgshzoSHGRldnJpbUBn
dW5kdXoub3JnAAoJENjDPf6Sz261DuMQAJyIqsCFsYapJ7cJritVe/YWM0SScvjv
hvaqqwvbBcvlTNwGX8UNtBWBbjaLNtX94JRnMSMX537GptwdaD/OXMQNmdeE2fko
I/FumGc/clTi5/0JstjWlylCYPAlYZ98TaR38DvdicIx6s3M25Z9gvtizo8u8Lto
8ZTtiPR2vIooZwdRZm3xE6eXY32aWU3ApOz1ezcEeWMKWwV+P2rydrWyCbQAdzoc
cAPcu+69lftP2T54Fz+yq861o58oksMq3Fcc/geVH/mYwYRN5bwXlqL14hIIs/gQ
RJIgOyrs5bhksP67FmWK8FQS37u7300A1l9LbS7hbwhLQQjGB1soBgU0FdXxCsPO
+fiGaKhpN8cJjuXSJK5jSA3iQidoaNkMYGHFxP51SILkEzjEqKoSHFLQ1PTtfnXs
lWLkZZgW9AjHfGK3+ZzSYwUYSfMp4PaMWpoyQXADz19jmABVPug+nUNKhjU4Nekf
b9n3GgYa9BJUoU6knIElSsessMcEWL2XMZAs2Y0347XfbnSwUcSAcCcrDSG10/UB
Ujnrcv7FdDX/6WaeFGqQTwfIRIf2izhVBm/zSHkvXO/lsIYFqSWh7jjC75HHdbCA
H3o2mNnu3uZ5xY70aciq32+bzRRwMm27u7Ij85g2ok9+ib/HY06m31MqTAZ5Kb4C
Aaat52FoOzWw
=upHP
-----END PGP SIGNATURE-----

--=-LB0yN4K6ik+4Z8cxJg0N--