Обсуждение: plperl.so no such file or directory

I'm migrating our database from CentOS release 5 (Final)  to Red Hat
Enterprise Linux Server release 6.1 (Santiago)

I've copied over the database file system and restarted the database
on the new server using the fresh postgresql install and this all
works fine

However if I use one of my plperl functions I get the error.

ERROR:  could not load library
"/net/nas20/bin/postgresql_8.4.2/lib/plperl.so": libperl.so: cannot
open shared object file: No such file or directory

I can see /net/nas20/bin/postgresql_8.4.2/lib/plperl.so is present

the limited googling I've done seems to indicate that I need to mess
round with  /etc/ld.so.conf
as root.  As I don't have root access on either machine is there
another option I can look at?

--
Michael

michael lush <mjlush@gmail.com> writes:
> However if I use one of my plperl functions I get the error.

> ERROR:  could not load library
> "/net/nas20/bin/postgresql_8.4.2/lib/plperl.so": libperl.so: cannot
> open shared object file: No such file or directory

> I can see /net/nas20/bin/postgresql_8.4.2/lib/plperl.so is present

It's complaining that it can't find libperl.so, not plperl.so.

The most likely reason is that the centos 5 build you're using was built
against a different Perl version than what you have on your RHEL6 box.
You need to get a PG version that was actually built for RHEL6.

            regards, tom lane