From: Jakub Olczyk <jwo@disroot.org>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Install postgresql-plpython for postgres 11
Date: Tue, 11 Jun 2019 16:48:22 +0200
Message-ID: <c4c44474-c0d5-63c3-196a-2c73a82ae1f7@disroot.org> (raw)
In-Reply-To: <004401d5204f$407da920$c178fb60$@opsveda.com>
References: <004401d5204f$407da920$c178fb60$@opsveda.com>
Hi Srikar!
On 11/06/2019 14:14, Srikar Vankadaru wrote:
> I wanted to install PL/Python (package name: postgresql-plpython) on
> Postgres 11.2 version running on AWS with Centos 7.
>
> 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
> 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 it
> needs the dependency to install postgresql-server.
>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jwo@disroot.org, pgsql-admin@lists.postgresql.org
Subject: Re: Install postgresql-plpython for postgres 11
In-Reply-To: <c4c44474-c0d5-63c3-196a-2c73a82ae1f7@disroot.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox