Re: libpython3.6 requirement problem

Hi,

On Thu, 2022-02-10 at 12:00 +0100, Jesper St John wrote:
> or postgresql 14, there seems to be a dependency on libpython3.6
> built into the -contrib package.

That is ok, please see below:

>
> More specifically, these libs:
> === hstore_plpython3.so
>          libpython3.6m.so.1.0 => /usr/lib64/libpython3.6m.so.1.0
> (0x00007ff431a3a000)
> === jsonb_plpython3.so
>          libpython3.6m.so.1.0 => /usr/lib64/libpython3.6m.so.1.0
> (0x00007fa912989000)
> === ltree_plpython3.so
>          libpython3.6m.so.1.0 => /usr/lib64/libpython3.6m.so.1.0
> (0x00007fad02ca1000)

<snip>

>
> I can install the postgresql 13 contrib package just fine.

On the build box, this is what I'm getting:

PostgreSQL 13:
# ldd /usr/pgsql-13/lib/hstore_plpython3.so | grep python
libpython3.6m.so.1.0 => /usr/lib64/libpython3.6m.so.1.0
(0x00007fde4b762000)

PostgreSQL 14:
# ldd /usr/pgsql-14/lib/hstore_plpython3.so | grep python
libpython3.6m.so.1.0 => /usr/lib64/libpython3.6m.so.1.0
(0x00007f30b4df2000)

So looks like they are the same. The reason is:

========

$ python3
Python 3.6.8 (default, Sep 9 2021, 07:49:02)
[GCC 8.5.0 20210514 (Red Hat 8.5.0-3)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>>

=============

Installed python39 (and -devel), and then tried to remove python36*
packages -- but it removes many other packages which depend on Python
3.6

> Python 3.6 was deprecated on 2021-12-23 according to
> https://devguide.python.org/devcycle/#end-of-life-branches and
> perhaps
> it's time to build with newer python version(s)?

OTOH, I can easily patch spec file to use Python 3.9 for RHEL 8, but
I'm not sure it's a good idea to do that in a minor release.

Maybe we should stick to the current deps, and change things for
PostgreSQL 15.

How does it sound?

Regards,

--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR