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.