perl 5.6.1 and PostgreSQL7.3.2

Поиск
Список
Период
Сортировка
Искать

perl 5.6.1 and PostgreSQL7.3.2

От:
Jie Liang <jliang@ipinc.com>
Дата:
I tried to use perl 5.6.1+ on PL/Perl, even though I successfully 
created libperl.so file and get compile done(gmake no complaint), but I 
still failed at load. Following is my steps:
(OS: FreeBSD-4.7, PostgreSQL 7.3.2, Perl 5.6.1)

cd /usr/ports/lang/perl5
make
cd work/perl-5.6.1
LD_LIBRARY_PATH=`pwd`
export LD_LIBRARY_PATH
sh Configure -Duseshrplib
For every question, I take the default, except:
Build a shared libperl.so (y/n) [n] y
What name do you want to give to the shared libperl? [libperl.a] 
libperl.so.5.6.1
after that
make
make test
make install
(perl 5.6.1 executable is installed at /usr/local/bin/)
make a symbolic like with libperl.so->libperl.so.5.6.1
which is under /usr/local/lib/perl5/5.6.1/mach/CORE/
then install postgresql
gmake
gmake install
(no complaint at all)
initdb
start postmaster
createlang plperl template1 (compliant)
EERROR:  Load of file /usr/local/pgsql/lib/plperl.so failed: dlopen 
'/usr/local/pgsql/lib/plperl.so' failed. 
(/usr/local/pgsql/lib/plperl.so: Undefined symbol "Perl_sv_2pv_flags")
ERROR:  Load of file /usr/local/pgsql/lib/plperl.so failed: dlopen 
'/usr/local/pgsql/lib/plperl.so' failed. 
(/usr/local/pgsql/lib/plperl.so: Undefined symbol "Perl_sv_2pv_flags")
createlang: language installation failed

What's wrong?

-- 
Jie LIANG

Software Engineer
St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@stbernard.com
www.stbernard.com


Re: perl 5.6.1 and PostgreSQL7.3.2

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Jie Liang  writes:
> EERROR:  Load of file /usr/local/pgsql/lib/plperl.so failed: dlopen 
> '/usr/local/pgsql/lib/plperl.so' failed. 
> (/usr/local/pgsql/lib/plperl.so: Undefined symbol "Perl_sv_2pv_flags")

You sure plperl was compiled against the same version of Perl you're
using?  The Perl binary API does vary depending on your version and
compilation options ...

			regards, tom lane
FAQ