Installing plpython on 8.4
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
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?
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.
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?