[GENERAL] Installing plpython on 8.4

Scott Bailey

unread,

Jul 2, 2009, 11:09:37 PM7/2/09

to

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?

Scott

--
Sent via pgsql-general mailing list (pgsql-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Peter Eisentraut

unread,

Jul 3, 2009, 4:37:16 AM7/3/09

to

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?

Scott Bailey

unread,

Jul 3, 2009, 7:57:35 PM7/3/09

to

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.

Peter Eisentraut

unread,

Jul 4, 2009, 12:50:22 PM7/4/09

to

On Saturday 04 July 2009 02:57:35 Scott Bailey wrote:
> 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

Perhaps you don't have the right libpython installed at the right place?