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:
[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
