I've just 1) installed redhat 6.1
2) installed perl-5.6.0 (sh Configure -Duseshrplib -d)
3) installed postgresql-7.0.2. (configure --with-perl --with-odbc)
4) add /usr/local/pgsql/lib to /etc/ld.so.conf
5) ran ldconfig
6) exported PGLIB=/usr/local/pgslq/lib
7) ran initdb
8) ran creatlang plperl template1
9) created a plperl function (hello world)
10) tried select test(); got the message:ERROR: Load of file /usr/local/pgsql/lib/plperl.so failed: libperl.so: cannot open shared object file: No such file or directory
11) tried: ldconfig -l /usr/local/pgsql/lib/plperl.so, got the message:
/usr/local/pgsql/lib/plperl.so is not a shared library
Incidentally, I moved /usr/lib/perl5 to perl5.old and then created a link: ln /usr/local/lib/perl5 /usr/lib/perl5 if that makes any difference.
Could definitely use some help!
TIA, -km