Dnia wtorek, 13 września 2005 17:24, Tom Lane napisał: > Marcin Giedz <marcin.giedz@xxxxxxxxxxxxxx> writes: > >> createlang: language installation failed: ERROR: could not load library > >> "/usr/local/postgresql-8.0.3/lib/plperl.so": > >> /usr/local/postgresql-8.0.3/lib/plperl.so: undefined symbol: Perl_croak > > I think you've got some kind of mismatch between the compilation options > for Perl proper and those for plperl. IIRC, Perl can spell its exported > function names in several different ways (eg, with or without the Perl_ > prefix). It looks like plperl is expecting a different convention than > what the libperl.so file was actually built with. > > Use ldd on plperl.so to double check which libperl it's trying to link > to. Double check that the Perl header files you compiled plperl against > came from the same Perl build that produced libperl.so. pgsql2-test:/usr/src/postgresql-snapshot/src/pl/plperl# ldd libplperl.so libdl.so.2 => /lib/tls/libdl.so.2 (0xb7fc7000) libm.so.6 => /lib/tls/libm.so.6 (0xb7fa4000) libpthread.so.0 => /lib/tls/libpthread.so.0 (0xb7f95000) libc.so.6 => /lib/tls/libc.so.6 (0xb7e60000) libcrypt.so.1 => /lib/tls/libcrypt.so.1 (0xb7e33000) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000) pgsql2-test:/usr/src/postgresql-snapshot/src/pl/plperl# I don't see any libperl.so :( But doesn't plperl use shared libperl library? "....libperl must have been built as a shared library, which is usually not the case in standard installations..." taken from README file I've changed configure script and put PERL variable as PERL=/usr/local/perl/bin/perl - so all things related to perl where taken from this place. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster