From: "Srikar Vankadaru" <srikar@opsveda.com>
To: "'Jakub Olczyk'" <jwo@disroot.org>,
	<pgsql-admin@lists.postgresql.org>
References: <004401d5204f$407da920$c178fb60$@opsveda.com>
 <c4c44474-c0d5-63c3-196a-2c73a82ae1f7@disroot.org>
In-Reply-To: <c4c44474-c0d5-63c3-196a-2c73a82ae1f7@disroot.org>
Subject: RE: Install postgresql-plpython for postgres 11
Date: Tue, 11 Jun 2019 21:49:22 +0530
Message-ID: <009101d52071$6f706d90$4e5148b0$@opsveda.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQIG1jEdWmtZRy95ofAJClw6VJ4e0AEs3NaMpinPCCA=
Content-Language: en-us
Precedence: bulk

Hi Jwo,

I am sorry, we have built Postgresql from the Centos 7 repository. Not =
from the source.
Is there any option to add this Language now ? If I need to rebuild with =
this option, what is the procedure to do that ?

Thanks,
Srikar=20

-----Original Message-----
From: Jakub Olczyk [mailto:jwo@disroot.org]=20
Sent: Tuesday, June 11, 2019 20:18
To: pgsql-admin@lists.postgresql.org
Subject: Re: Install postgresql-plpython for postgres 11

Hi Srikar!

On 11/06/2019 14:14, Srikar Vankadaru wrote:
> I wanted to install PL/Python (package name: postgresql-plpython) on=20
> Postgres 11.2 version running on AWS with Centos 7.
>=20
> Is there any way  to add this language for my running postgres server =
?
> As we have used the source package to install Postgresql 11 without=20
> giving option |--with-python|

As I understand you have compiled the binaries yourself. In that case I =
think the only option is to recompile from the same sources with =
different configuration (this should be fairly fast unless you removed =
the object files). I don't know if there is a smooth way to use =
prepackaged (in form of RPM) version of PL/Python in this case.

> I tried to find for packages in Centos 7 repo, but found this one and=20
> it needs the dependency to install  postgresql-server.
>=20
> postgresql-plpython
> x86_64
> 9.2.24-1.el7_5                                     base

This is version of the PL/Python for the base system version of =
PostgreSQL. This version is very old and not supported anymore by the =
developers. You need to have matching version of Postgres server and =
PL/Python.

Maybe others can give more insight if marrying compiled and packaged =
extension can work. I'd use the packaged version of Postgres server and =
PL/Python from official repository here: http://yum.postgresql.org

Cheers!
jwo