Re: Installing plpython on 8.4 - Mailing list pgsql-general

From Scott Bailey
Subject Re: Installing plpython on 8.4
Date
Msg-id 4A4E9AEF.60009@comcast.net
Whole thread Raw
In response to Re: Installing plpython on 8.4  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Installing plpython on 8.4
List pgsql-general
Peter Eisentraut wrote:
> On Friday 03 July 2009 06:09:37 Scott Bailey wrote:
>> I'm having trouble installing plpython in 8.4. I tried under Windows
>> (one click installer from EDB) and under Ubuntu (linux binary).  In both
>> cases I was told:
>> could not load library 8.4/lib/postgresql/plpython.(so|dll)
>>
>> Both systems have python 2.5 installed. And plpython was working in 8.3
>> (and I believe 8.4 B1) on both. Any ideas what I'm doing wrong?
>
> I tried with the 8.4.0 Debian package and it worked.
>
> Could you start by describing exactly what you entered and the exact output
> and error message that came back?
>

On ubuntu from command line:
 > createlang -h localhost -p 5433 plpythonu template1

createlang: language installation failed: ERROR:  could not load library
"/opt/postgres/8.4/lib/postgresql/plpython.so": libpython2.3.so.1.0:
cannot open shared object file: No such file or directory

And in sql:
CREATE PROCEDURAL LANGUAGE 'plpythonu' HANDLER plpython_call_handler;

ERROR:  could not load library
"/opt/postgres/8.4/lib/postgresql/plpython.so": libpython2.3.so.1.0:
cannot open shared object file: No such file or directory

I won't have access to the windows machine until Monday, but the error
message was the same except 'so' was 'dll'

It looks like it wants Python 2.3 from the error message, I hope that is
not the case.

pgsql-general by date:

Previous
From: Michael Black
Date:
Subject: Re: Store derived data or use view?
Next
From: Reece Hart
Date:
Subject: Re: Q: data modeling with inheritance