Thread: 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?