X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 61F98D8D45 for ; Tue, 13 Sep 2005 13:37:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07927-09 for ; Tue, 13 Sep 2005 16:37:28 +0000 (GMT) Received: from mail.eulerhermes.pl (host-ip43-68.crowley.pl [85.128.68.43]) by svr1.postgresql.org (Postfix) with ESMTP id 59E54D8D35 for ; Tue, 13 Sep 2005 13:37:24 -0300 (ADT) Received: from [192.168.49.9] (helo=xterm.podsiec) by mail.eulerhermes.pl with esmtpa (Exim 4.42) id 1EFDme-0007Jm-IT; Tue, 13 Sep 2005 18:37:24 +0200 From: Marcin Giedz Organization: Euler Hermes To: pgsql-admin@postgresql.org Subject: Re: plperl again but different problem Date: Tue, 13 Sep 2005 18:37:20 +0200 User-Agent: KMail/1.7.1 Cc: Tom Lane References: <200509131418.02818.marcin.giedz@eulerhermes.pl> <200509131431.16634.marcin.giedz@eulerhermes.pl> <23418.1126625057@sss.pgh.pa.us> In-Reply-To: <23418.1126625057@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200509131837.20948.marcin.giedz@eulerhermes.pl> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/140 X-Sequence-Number: 18877 Dnia wtorek, 13 wrze=C5=9Bnia 2005 17:24, Tom Lane napisa=C5=82: > Marcin Giedz writes: > >> createlang: language installation failed: ERROR: could not load libra= ry > >> "/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 =3D> /lib/tls/libdl.so.2 (0xb7fc7000) libm.so.6 =3D> /lib/tls/libm.so.6 (0xb7fa4000) libpthread.so.0 =3D> /lib/tls/libpthread.so.0 (0xb7f95000) libc.so.6 =3D> /lib/tls/libc.so.6 (0xb7e60000) libcrypt.so.1 =3D> /lib/tls/libcrypt.so.1 (0xb7e33000) /lib/ld-linux.so.2 =3D> /lib/ld-linux.so.2 (0x80000000) pgsql2-test:/usr/src/postgresql-snapshot/src/pl/plperl# =20 I don't see any libperl.so :( But doesn't plperl use shared libperl library= ?=20 "....libperl must have been built as a shared library, which is usually not= =20 the case in standard installations..." taken from README file I've changed configure script and put PERL variable as=20 PERL=3D/usr/local/perl/bin/perl - so all things related to perl where taken= =20 from this place. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster