Re: plperl/createlang issue

On Tue, 2003-11-11 at 21:22, Ed L. wrote:
> $ createlang plperl template1
> ERROR:  Load of file /opt/pgsql/installs/postgresql-7.3.4/lib/plperl.so
> failed: libperl.so: cannot open shared object file: No such file or
> directory
> createlang: language installation failed

 I had the exact problem recently, and I found the solution.

 1) First, locate your libperl.so file. On my PPC box it was:

 [chris@mafalda chris]$ locate libperl.so
/usr/lib/perl5/5.8.0/ppc-linux-thread-multi/CORE/libperl.so


 2) Add that directory to /etc/ld.so.conf

 3) run ldconfig (as root)

 Then your creatlang statement should work.

 Hope that helps.

Cheers,

Chris

> But it sure looks like its there to me:
>
> $ ls -l /opt/pgsql/installs/postgresql-7.3.4/lib/plperl.so
> -rwxr-xr-x    1 pg       pg          35770 Nov 11 19:39
> /opt/pgsql/installs/postgresql-7.3.4/lib/plperl.so*
>
> I *think* my perl is threaded based on perl -v:
>
> $ perl -v
>
> This is perl, v5.8.0 built for i386-linux-thread-multi
> ...
>
> Any clues for the clueless?
>
> TIA.
>
> Ed
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend