Subject: Re: Install postgresql-plpython for postgres 11
To: pgsql-admin@lists.postgresql.org
References: <004401d5204f$407da920$c178fb60$@opsveda.com>
From: Jakub Olczyk <jwo@disroot.org>
Openpgp: preference=signencrypt
Autocrypt: addr=jwo@disroot.org; keydata=
 xsBNBFPd644BCACT+Fikmmlt4WqTJNIQUgEMW/iPlI71r31XSX+GsX8YHKFsKZrA/QINy0fE
 1n/fdVLHt+GI21yv25+skUaCxlx1mKsr0Utusuhb+GlNxeveD9FmRRN/A3FT0PufK7Y3fFI8
 BCIcfhkimV7f6W2GzDijv/mSOWyHhJH7Adun5DdXiiObQFSkgfGLaHEb5f62DTCLw6RUI6HN
 saCzeOhm7rCPC1fpX4Ydg8O4/Use4rboKDpsR7odR8SalifgysPHu3avwANvdb4UsxeI8D03
 0TP3PgDBXovIEqIPqO87OydJuz69WeWOonJ10OzNsBPOtY5La1Zm6X0JXgdXz1cCGiZ7ABEB
 AAHNHkpha3ViIE9sY3p5ayA8andvQGRpc3Jvb3Qub3JnPsLAlwQTAQoAQQIbAwULCQgHAgYV
 CgkICwIEFgIDAQIeAQIXgAIZARYhBEBQIlDVAjQCDxPL/Xg9Ix6LH5X1BQJb8xlJBQkJ9mE7
 AAoJEHg9Ix6LH5X1nXIIAI62elPjEwUmTriAi8GdtW/8IgESqfR7opt7wymItpFjpRIW+SNj
 +OaFus+fJDXsA5sOAo0h9UPMHskuIm6i8wgq7K+AL5LokIjDSElcXeErywlcQFMjSSApKnMY
 1uoHxo1AVfqBc8jXR4z2V4P71IS+KChm8OIqT+bJMq5+yURjC1GZYWdeL8H38BRyJ9CJOqAt
 T7dPUcCeLMjvdWOGB9+Rg8STwLv4GNwhIstVChg+Zjl0B3RRu0w8BcFFT2HBDwBc0ntGEV9d
 ZQ0lGGCU2FZzu2A0iHgsAu/ez1Bu9P9PXLbjh1FFtfd6bhs4NdP3/po7fwKStt7HRQze+UVB
 mGHOwE0EU93rmAEIAIl/8wPAZAiL9h5RjMlwnNi9wbwdbDFM64SBVrVnwhFZVIMLQUsd6Ado
 +ngUAT38ZHjD0/DD59AzCgpVESquNf2Lul4rzWiItuncHkh2ttFUUGftPfquUP976zEici4t
 CvkimgaZBOx7Of/5cmvtb/fAs+ZnQ5CCeQHxBUBh96GRV2lVY3cnu8dOlE/PBOE5t5Q7JYyX
 8cFs8HxmV3nB7FYoKnrwi2/pxG0fAcClOz2QPxIY/Hkpfayu05BT637fde7QhDZFY1Qhm+h2
 1WyjHd6oDU6Sq9G1NL7tVXAJPzEkhL+m5xcreHQe/nDYXcrpkrQQjzCC5QSK3rNUXpWWm80A
 EQEAAcLAfAQYAQoAJgIbDBYhBEBQIlDVAjQCDxPL/Xg9Ix6LH5X1BQJb8xmZBQkJ9mGBAAoJ
 EHg9Ix6LH5X18kAH/0u9xueuQv+OVPZ+60ryXKMgDHV2rKn7FBzQxfESYL1OVREarwx2/Rt9
 0ASban6wTMGsz0UbQISBjEvSV7wh1x82O562eyZLuehGrLfz9Jydx/DEyO56dVqluJUGY3mD
 cfPrjvqDmRDVxx2O3k4Bed51m4hIn9fbUgC/YXTaIynVf22i0wAOGDh4L6oBbY5mUIg0JcQb
 Mj7FR4bjKzShAf7EK8xX49ZJJggs+iUJB0moP6RC3xdf9oMnBV9pbxpR7fgPw4uGpTW3sHLE
 zgA0IsI9zhHVnImVUvFViEYIyAL5xDJzKJBssqHOLYvm7Uve8mVF+om0/L1Wi5SwjOWqzwM=
Message-ID: <c4c44474-c0d5-63c3-196a-2c73a82ae1f7@disroot.org>
Date: Tue, 11 Jun 2019 16:48:22 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.7.0
Mime-Version: 1.0
In-Reply-To: <004401d5204f$407da920$c178fb60$@opsveda.com>
Content-Type: text/plain; charset=UTF-8
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Precedence: bulk

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