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 9CFFDD6D9D for ; Tue, 13 Sep 2005 12:18:05 -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 93267-03 for ; Tue, 13 Sep 2005 15:18:03 +0000 (GMT) Received: from mail.eulerhermes.pl (host-ip43-68.crowley.pl [85.128.68.43]) by svr1.postgresql.org (Postfix) with ESMTP id 4F00BD8D4A for ; Tue, 13 Sep 2005 12:18:02 -0300 (ADT) Received: from [192.168.49.9] (helo=xterm.podsiec) by mail.eulerhermes.pl with esmtpa (Exim 4.42) id 1EFCXn-00079c-2S for pgsql-admin@postgresql.org; Tue, 13 Sep 2005 17:17:59 +0200 From: Marcin Giedz Organization: Euler Hermes To: pgsql-admin@postgresql.org Subject: Re: plperl again but different problem Date: Tue, 13 Sep 2005 17:17:55 +0200 User-Agent: KMail/1.7.1 References: <200509131418.02818.marcin.giedz@eulerhermes.pl> <4326C927.2010004@qresc.com> <200509131701.32727.marcin.giedz@eulerhermes.pl> In-Reply-To: <200509131701.32727.marcin.giedz@eulerhermes.pl> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200509131717.55886.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/136 X-Sequence-Number: 18873 Dnia wtorek, 13 wrze=C5=9Bnia 2005 17:01, Marcin Giedz napisa=C5=82: Additional info: I've also checked plperl with postgresql snapshot - proble= m=20 still exists ;( -=20 didn't anyone have something similar? or maybe I'm only one who uses Sarge= =20 3.1? :D:D Marcin > Dnia wtorek, 13 wrze=C5=9Bnia 2005 14:42, Sergiusz Jarczyk napisa=C5=82: > > Hi Marcin > > > > Marcin Giedz napisa=C5=82(a): > > >Hello.. > > > > > >I've installed plperl.so in postgresql lib directory but when I try to > > > create lang, such error occures: > > > > > >pgsql2-test:~# su pgadmin > > >pgadmin@pgsql2-test:/root$ /usr/local/postgresql/bin/createlang -p 5433 > > >plperlu pl > > >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_cro= ak > > >pgadmin@pgsql2-test:/root$ > > > > > >I've even compiled perl from sources but still have this error. What's > > > going on? > > > > If you have both Perl installed (from distro and compiled from the > > source), it's mostly the problem of the wrong > > libperl.so used by Postgres, i.e. it uses not the one it was compiled > > with... > > No... I simply removed the old one taken from deb I have only one - new > installed from sources. > > Marcin > > > Sergiusz > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster