RE: Plperl make fails with Error1 at plperl.o (7.0.3)

Tom,

Again your help was excellent and on target.

I had gone through the fun and games of building a shared libperl.so, and
the plperl.so... but...

The LD_LIBRARY_PATH was the culprit. As I'm running RedHat, by default it
does not create a /usr/local/bin, but I created one by hand, and then dumped
my libperl.so there... Well... This was not in the "/etc/ld.so.conf" file.
So I added the path, and ran the ldconfig and presto... Everything works
very well.

With Perl up and running I'm actually able to make PostgreSQL drive around
the block a few times.

Thank you again.

-Michael

> -----Original Message-----
> From: pgsql-interfaces-owner(at)postgresql(dot)org
> [mailto:pgsql-interfaces-owner(at)postgresql(dot)org]On Behalf Of Tom Lane
> Sent: Sunday, December 10, 2000 5:12 PM
> To: mykarz(at)miyabara(dot)com
> Cc: pgsql-interfaces(at)postgresql(dot)org
> Subject: Re: [INTERFACES] Plperl make fails with Error1 at plperl.o
> (7.0.3)
>
>
> "Michael Miyabara-McCaskey" <mykarz(at)miyabara(dot)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
>