Re: Problem with pl/perl in postgresql 8.0rc1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Boone <robert(at)rlb3(dot)com>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Problem with pl/perl in postgresql 8.0rc1
Date: 2004-12-17 17:22:52
Message-ID: 20950.1103304172@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Robert Boone <robert(at)rlb3(dot)com> writes:
> I get:
> createlang: language installation failed: ERROR: could not load
> library "/usr/lib/pgsql/plperl.so": libperl.so: cannot open shared
> object file: No such file or directory

You have to read the message carefully: plperl.so is trying to invoke
libperl.so, and that file is the one that's not being found.

This suggests to me that your Perl installation isn't quite the same as
the one the RPM was built against. Try
readelf -d /usr/lib/pgsql/plperl.so
and see if there's an RPATH entry. On my plperl.so I see
0x0000000f (RPATH) Library rpath: [/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE]
and indeed I have /usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
so everything works. But with all those version numbers buried in the
path, a slightly different Perl vintage would make it break.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Anaya 2004-12-17 17:33:58
Previous Message Tom Lane 2004-12-17 17:14:25 Re: sorting problem

Browse pgsql-novice by date

  From Date Subject
Next Message Devrim GUNDUZ 2004-12-17 17:52:19 Re: Problem with pl/perl in postgresql 8.0rc1
Previous Message Michael Fuhr 2004-12-17 17:13:47 Re: Problem with pl/perl in postgresql 8.0rc1