loading plpython error

[Alan Nilsson]

Platform:  Linux x86-64, CentOS 6, Postgres 11.1.

We have installed from the YUM repo.  The server runs fine but we are trying to 
add python support.

yum install postrgesql11-contrib postgresql11-plpython

I can see the installed files in the correct locations but when we invoke 
create extension, we are greeted with the following error:

ERROR:  could not load library "/usr/pgsql-11/lib/plpython2.so": 
/usr/pgsql-11/lib/plpython2.so: undefined symbol: getmissingattr

Is there something yet to be installed?  Is this a package error?  Any hints to 
fixing?

thanks
alan

Re: loading plpython error

[Alan Nilsson]

Indeed, that was it.  Thank you Tom!

alan


> On Feb 14, 2019, at 4:42 PM, Tom Lane  wrote:
> 
> Alan Nilsson  writes:
>> Platform:  Linux x86-64, CentOS 6, Postgres 11.1.
>> We have installed from the YUM repo.  The server runs fine but we are trying 
>> to add python support.
> 
>> yum install postrgesql11-contrib postgresql11-plpython
> 
>> I can see the installed files in the correct locations but when we invoke 
>> create extension, we are greeted with the following error:
> 
>> ERROR:  could not load library "/usr/pgsql-11/lib/plpython2.so": 
>> /usr/pgsql-11/lib/plpython2.so: undefined symbol: getmissingattr
> 
> getmissingattr is a new core-PG function in 11.2.  I believe this means
> you're trying to load an 11.2 build of plpython2.so into an 11.1 server.
> You need to either update the server, or find an 11.1 build of plpython.
> 
>   regards, tom lane
> 

python install location

[Alan Nilsson]

How does postgres determine which install of python to use in conjunction with 
plpythonu?  We have a CentOS6 machine with python 2.6 and 2.7 installed on it.  
The 2.6 version is in the canonical location and the version which gets used 
when using the plpython extension.

Is there a way, in postgres, short of rebuilding that we can tell postgres 
which install of python to use when invoking plpython?

thanks
alan