Re: plperl/createlang issue - Mailing list pgsql-general

From Christopher Murtagh
Subject Re: plperl/createlang issue
Date
Msg-id 1068645663.879.3.camel@mafalda.murtagh.name
Whole thread Raw
In response to plperl/createlang issue  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: SQL-question: returning the id of an insert querry
Next
From: Tom Lane
Date:
Subject: Re: multibyte support