Re: libpython3.6 requirement problem - Mailing list pgsql-pkg-yum

From Devrim Gündüz
Subject Re: libpython3.6 requirement problem
Date
Msg-id beaa93f2a3fbc4d111cfa69bac35298fc540e8ce.camel@gunduz.org
Whole thread Raw
In response to libpython3.6 requirement problem  (Jesper St John <admin@zonezero.se>)
List pgsql-pkg-yum
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

Attachment

pgsql-pkg-yum by date:

Previous
From: Vishnu Bharathi P
Date:
Subject: Bad GPG signature error while trying to install on arm64
Next
From: Devrim Gündüz
Date:
Subject: Re: Bad GPG signature error while trying to install on arm64