Re: pg12 rc1 on CentOS8 depend python2

From: keisuke kuroda <keisuke(dot)kuroda(dot)3862(at)gmail(dot)com>
To: Christoph Berg <myon(at)debian(dot)org>
Cc: Devrim Gündüz <devrim(at)gunduz(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-pkg-yum(at)postgresql(dot)org
Subject: Re: pg12 rc1 on CentOS8 depend python2
Date: 2019-10-04 01:03:50
Message-ID: CANDwggL6J2VnX+X10tSGU=EnLcLg=Us3Pr5XAkOoHZ-CoFXwcg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-pkg-yum

> Users of these (now contrib) modules need to have
> postgresql12-plpython3 installed anyway, so it's unlikely you'd be
> breaking anyone's installation.

I agree.
To use these EXTENSION(hstore_plpython,jsonb_plpython, and ltree_plpython),
we need to install plpythonu anyway.
I don't think it would be a problem to move these EXTENSIONs to the
plpython package.

By using the rpm "--nodeps" option,
PostgreSQL 12 could be installed on CentOS8 where python2 is not installed.

# rpm -ivh --nodeps *
1:postgresql12-libs-12.0-1PGDG.rhel################################# [
20%]
2:postgresql12-12.0-1PGDG.rhel8 ################################# [
40%]
3:postgresql12-contrib-12.0-1PGDG.r################################# [
60%]
4:postgresql12-server-12.0-1PGDG.rh################################# [
80%]
5:postgresql12-docs-12.0-1PGDG.rhel#################################
[100%]

plpython could be installed in the same way.

# rpm -ivh --nodeps postgresql12-plpython-12.0-1PGDG.rhel8.x86_64.rpm
1:postgresql12-plpython-12.0-1PGDG.#################################
[100%]

Of course, "CREATE EXTENSION plpythonu" has caused an ERROR because CentOS8
isn't installed python2.

postgres=# CREATE EXTENSION plpythonu;
ERROR: could not load library "/usr/pgsql-12/lib/plpython2.so":
libpython2.7.so.1.0: cannot open shared object file: No such file or
directory postgres=#

"CREATE EXTENSION hstore_plpython2u" has caused an ERROR because required
"plpython2u".

postgres=# CREATE EXTENSION hstore_plpython2u;
ERROR: required extension "plpython2u" is not installed
HINT: Use CREATE EXTENSION ... CASCADE to install required extensions too.

By the way, "python2-libs is needed" error has occurred when
"postgresql12-12.0-1PGDG.rhel8.x86_64.rpm" and
"postgresql12-libs-12.0-1PGDG.rhel8.x86_64.rpm" install.

# rpm -ivh postgresql12-12.0-1PGDG.rhel8.x86_64.rpm
postgresql12-libs-12.0-1PGDG.rhel8.x86_64.rpm
error: Failed dependencies:
python2-libs is needed by postgresql12-12rc1-1PGDG.rhel8.x86_64

In this case, I think that python2-libs is not necessary.

Best Regards.
Keisuke Kuroda

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Arnaud L. 2019-10-04 07:19:13 Re: psql \copy hanging
Previous Message Alvaro Herrera 2019-10-03 22:38:43 Re: PMChildFlags array

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Devrim Gündüz 2019-10-04 15:13:46 Re: PG 12 rpm repo breaks yum
Previous Message Sébastien Besson 2019-10-03 19:49:12 Re: Broken python2-psycopg2-2.8.3-2.rhel7.x86_64.rpm package for PostgresQL versions 9.6 or lower