Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uEpiB-00DdzD-0r for pgsql-pkg-yum@arkaria.postgresql.org; Tue, 13 May 2025 13:30:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uEpi8-005IO2-9e for pgsql-pkg-yum@arkaria.postgresql.org; Tue, 13 May 2025 13:30:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uEpi8-005INu-3s for pgsql-pkg-yum@lists.postgresql.org; Tue, 13 May 2025 13:30:20 +0000 Received: from ns7.gunduz.org ([165.232.104.158]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uEpi4-001gK8-3D for pgsql-pkg-yum@lists.postgresql.org; Tue, 13 May 2025 13:30:19 +0000 Received: from dell-laptop07.gunduz.org (unknown [85.100.221.78]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-256) server-digest SHA256) (No client certificate requested) by ns7.gunduz.org (Postfix) with ESMTPSA id 0D62E30002C1 for ; Tue, 13 May 2025 13:30:15 +0000 (UTC) Message-ID: Subject: Heads up: Barman, Patroni, psycopg and Python 3.12 From: Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= To: PostgreSQL RPM Packaging Date: Tue, 13 May 2025 16:30:13 +0300 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="=-aAMMAOJhQXbpO/3n0bmw" User-Agent: Evolution 3.56.1 (3.56.1-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-aAMMAOJhQXbpO/3n0bmw Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, 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=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. So the plan is using Python 3.12 for RHEL 8 and 9 and using whatever available for Fedora and RHEL 10. 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. Barring any objections, I plan to work on this soon. Regards, --=20 Devrim G=C3=BCnd=C3=BCz Open Source Solution Architect, PostgreSQL Major Contributor BlueSky: @devrim.gunduz.org , @gunduz.org --=-aAMMAOJhQXbpO/3n0bmw Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- iQJGBAABCgAwFiEEH8GKHNUOKtDEiyD22MM9/pLPbrUFAmgjSWUSHGRldnJpbUBn dW5kdXoub3JnAAoJENjDPf6Sz2615FcQAIBheUZMIgFNrnyMPEOoufOZl2lYiktY 9bCFFyriPANVTV1S5F84BjlL46IUIAJ2Yu52E0UOVqg6848HFY2WqvsHM2y4eYYo ujujBR3syw+v90sFYyItrXHqgoxD6Q5DAupOXpwstrx+f4PQsgIO2szPIAgnW8ZG SkxX9zKxAcQxBZPaTa+ExZMz09VuK4NHx9R8/xOsxilTFUEFzJqhr/MyK35lnBXw JGyA7qY5OR1HZvhwcdbRUuVYxNCfbo7BfZNilKidp3uiaEsZY59aLaDVYI5uMeSB zmpcCC7hEWma/LDKGcUsnnN2PPz8Vl6IbECq+DAQxbm3xeU0L5d09f0xKClHDDJ7 IVHaxJQ7kV727b7Nxg57PZqCHw+YVukKAnJd0ZMPW2x1OVsMGCjlhnwl5U+1Nlan NMdulmJo+CPFK013IZOM5RmIGBnDB6WPsThipixVqmjgd2dZ4m/6nmhuhQw6D/w0 DhDrp2en+9MNbUfeEX5yTKH4qAOXk68PUFrKnW/emqg1fx3EpA2r9bV/CGC77y8M npxl0YpMoGQz8u1UH5vOrH+dg0S3dWjgIZtHcRrPA63epXXbDC8LgrD9ZJQUDJYP GdJH28JbSsDh8/wAEHb/amqDiSaH1qAaUOJFdJojG2fe+Nw5aMaqjzBtsJjWalhb ba3tMaG6A3cz =PBJ0 -----END PGP SIGNATURE----- --=-aAMMAOJhQXbpO/3n0bmw--