Re: loading plpython error
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 >
Re: loading plpython error
> On 2/14/19 4:17 PM, Alan Nilsson wrote: > > 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? I see one possibly related issue talked about on a Debian list that extensions compiled against PostgreSQL 11.2 would likely not load into previous releases due to this missing symbol. https://bugs.launchpad.net/ubuntu/+source/skytools3/+bug/1815665 I would guess this is a related version mismatch; likely in the build/release process.
Re: loading plpython error
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
Re: loading plpython error
On 2/14/19 4:34 PM, Adrian Klaver wrote: On 2/14/19 4:17 PM, Alan Nilsson wrote: 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? What happens if you try?: CREATE EXTENSION plpython3u; Forget the above, I looked at: https://yum.postgresql.org/testing/11/redhat/rhel-6-x86_64/repoview/postgresql11-plpython.html and it only includes plpython2u. thanks alan -- Adrian Klaver adrian.kla...@aklaver.com
Re: loading plpython error
On 2/14/19 4:17 PM, Alan Nilsson wrote: 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? What happens if you try?: CREATE EXTENSION plpython3u; thanks alan -- Adrian Klaver adrian.kla...@aklaver.com
Re: loading plpython error
On 2/14/19 4:17 PM, Alan Nilsson wrote: 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? Is there Python 2.x on this machine? As I understand it by default plpython is for Python 2.x thanks alan -- Adrian Klaver adrian.kla...@aklaver.com
loading plpython error
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