I suspect at this point I may need to recompile things? I'm not sure
what the trouble is. Can I try the directions in
http://www.postgresql.org/idocs/index.php?plperl-install.html
in lieu of a complete recompilation? The runit does indicate that
with-perl was included, so I don't understand why this didn't
work, but perhaps (see below) because the timestamps are different?
I didn't have any better luck with trying to createlang on plpgsql either...
......
(Also, trying to link libperl.so.1 to libperl.so failed. And I don't think
it's a shared library problem, as I'm not getting that message anywhere.)
The error message is now a bit more detailed:
> createlang -L /usr/local/pgsql/lib -d Text plperl
ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: ld.so.1: /usr/local
/pgsql/bin/postmaster: fatal: libperl.so.1: open failed: No such file or direct
ory
createlang: language installation failed
I am running this command from the account under which psql was installed
& started (which shd be superuser).
I do note that:
> ls -l /usr/local/pgsql/lib/plperl.so
- -rwxr-xr-x 1 root other 93252 Feb 25 2002 /usr/local/pgsql/lib/plpe
rl.so*
is earlier than the dates of the compilation in the src/pl dir:
> ls -l /export/home/download/postgresql-7.2/src/pl/plperl/
total 184
- -rw-r--r-- 1 nishad other 754 Sep 16 2001 GNUmakefile
- -rw-r--r-- 1 nishad other 17459 Aug 16 14:21 Makefile
- -rw-r--r-- 1 nishad other 2317 Aug 26 2001 Makefile.PL
- -rw-r--r-- 1 nishad other 440 Dec 19 2000 README
- -rw-r--r-- 1 nishad other 2402 Aug 16 14:21 SPI.c
- -rw-r--r-- 1 nishad other 7396 Aug 16 14:21 SPI.o
- -rw-r--r-- 1 nishad other 1211 Jun 8 2001 SPI.xs
drwxr-xr-x 4 nishad other 512 Aug 16 14:21 blib/
- -rw-r--r-- 1 nishad other 325 Jun 8 2001 eloglvl.c
- -rw-r--r-- 1 nishad other 78 Jun 8 2001 eloglvl.h
- -rw-r--r-- 1 nishad other 2008 Aug 16 14:21 eloglvl.o
- -rw-r--r-- 1 nishad other 0 Aug 16 14:21 plperl.bs
- -rw-r--r-- 1 nishad other 24021 Jan 24 2002 plperl.c
- -rw-r--r-- 1 nishad other 18468 Aug 16 14:21 plperl.o
- -rw-r--r-- 1 nishad other 0 Aug 16 14:21 pm_to_blib
- -rw-r--r-- 1 nishad other 7519 Nov 5 2001 ppport.h
Hm....??? Perhaps recompilation is in order... Or just reinstallation?
(of what? no .so file here)
Thanks,
--Cindy
