"Michael Miyabara-McCaskey" <mykarz@miyabara.com> writes:
> ... I am now getting the error message that:
> ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: shared object not
> open
Hm. That's a pretty unhelpfully worded error message, isn't it?
You may be able to find a more extensive error report in the
postmaster's log file, assuming you routed the postmaster's stderr
to someplace other than /dev/null.
But I'll bet that the real problem is not with plperl.so but with Perl's
libperl.so, which plperl.so depends on. On the Perl versions I've used,
a shared library version of libperl is *not* built unless you
specifically request it while configuring the Perl build. On some
platforms you get a usable shlib anyway, on some you don't.
Another possibility is that libperl.so exists but is not being found
by the dynamic loader; you may need to run ldconfig or set
LD_LIBRARY_PATH or some such to include the proper directory in the
Perl install in the search path.
regards, tom lane