Our machine is running:
Python 2.2 (#1, Feb 24 2002, 16:21:58)
[GCC 2.96 20000731 (Mandrake Linux 8.2 2.96-0.76mdk)] on linux-i386
Our Postgres source is from ftp.postgresql.org[64.49.215.8]:21 (via 'wget'):
-rw-r--r-- 1 postgres postgres 9239158 Aug 22 23:25
postgresql-7.2.2.tar.gz
We had to get the Python 2.2.1 source and fiddle with Postgres' makefile
'-I' statement (in the appropriate place, we think) to point to the
Python headers, but everything seemed to build and install OK after that.
We brought up postmaster, added 'plpgsql' to 'template1', no problem.
However, when we try to add 'plpython':
[postgres@linuxbox postgres]$ /usr/local/pgsql/bin/createlang plpython
template1
ERROR: Load of file /usr/local/pgsql/lib/plpython.so failed:
/usr/local/pgsql/lib/plpython.so: undefined symbol: PyExc_IOError
ERROR: Load of file /usr/local/pgsql/lib/plpython.so failed:
/usr/local/pgsql/lib/plpython.so: undefined symbol: PyExc_IOError
createlang: language installation failed
We noticed 'libplpython.so' in 'src/pl/plpython', so we set
'LD_LIBRARY_PATH' - same error. We also added '/usr/lib/'
(libpython2.2.so.0.0 is there) to LD_LIBRARY_PATH - no change.
We *love* Python, and think it will be ideal for a good number of our
stored procedures/functions, and in fact this Postgres installation is
to support a Zope application we are currently developing/using with
Postgres 7.2.
We (obviously) are not terribly skilled at installing Postgres (though
we do usually build from source) - our efforts are directed elsewhere -
could someone help us with what is probably a blindingly obvious problem
to a Postgres expert?
Permissions, perhaps?
--
One OS to rule them all, one OS to find them,
One OS to bring them all and in the database bind them,
In the Land of Redmond, where the Shadows lie.