Heads up: Barman, Patroni, psycopg and Python 3.12

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

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,
--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
BlueSky: @devrim.gunduz.org , @gunduz.org