Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bWhs3-0004kR-RO for pgsql-performance@arkaria.postgresql.org; Mon, 08 Aug 2016 10:33:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bWhs2-0000dF-4B for pgsql-performance@arkaria.postgresql.org; Mon, 08 Aug 2016 10:33:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bWhs0-0000cD-FT for pgsql-performance@postgresql.org; Mon, 08 Aug 2016 10:33:20 +0000 Received: from nm33.bullet.mail.gq1.yahoo.com ([98.136.217.16]) by magus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bWhrx-0006vT-T8 for pgsql-performance@postgresql.org; Mon, 08 Aug 2016 10:33:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s2048; t=1470652393; bh=yMAdgye0zm2thNlVQly4CHHA8r1Pvb2Nv/hAdhzZsJw=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=b9AetGEksS40QYLH/F7s0jgBpGs4VO4Gvn0HPXXW4IhqQF/DyR76qwx3zMp1jincdoXBVcWKc9XpEM5nmRS+th2f0zujD8vH3I7Bfa8xA+EqQr/6HmZZ9DE+Cg27BNN4aulthZM/dOTGbzqdN0aHRhuJBMVrYooclBUTlnsqyLzgg+hf87y6PtlZ9hpnMeMUnoobm/xl+AVsaX0h4KSM9D6zicDTImkVrOTxxArlOvfHDoCDymNAwEc5htbSvVDNfQPUqtmIADCSmKd1trrk87KhLtGCWIUEGjyX/59fWVhGHX3g7iYQYvYomTak5Vc4uMH15BXQAJzfuII0fz4z3w== Received: from [127.0.0.1] by nm33.bullet.mail.gq1.yahoo.com with NNFMP; 08 Aug 2016 10:33:13 -0000 Received: from [98.137.12.60] by nm33.bullet.mail.gq1.yahoo.com with NNFMP; 08 Aug 2016 10:30:22 -0000 Received: from [106.10.166.119] by tm5.bullet.mail.gq1.yahoo.com with NNFMP; 08 Aug 2016 10:30:21 -0000 Received: from [106.10.151.254] by tm8.bullet.mail.sg3.yahoo.com with NNFMP; 08 Aug 2016 10:30:21 -0000 Received: from [127.0.0.1] by omp1003.mail.sg3.yahoo.com with NNFMP; 08 Aug 2016 10:30:21 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 281716.7318.bm@omp1003.mail.sg3.yahoo.com X-YMail-OSG: HI2crJYVM1mLAQmzrmsQXwXsydJwLzSGG0bkbkeiF9HavPs_QkpX8TkwemSn6Kq fApuF0ZQp159eXjh3_4U51by8WvQ4ivfVufGOecfovtJAjUZnLGtzle4d8aA5B3m.XaOXK7TuO0M sg1L0Yrv_Rv6kcXNAonE4AnaGYqlTz_Y9w7A6zpUgq.BCmSDInR0YSCCRyLHkIMmSR7HEaedlsDA S4e6BfCNzAg8ZQYoAtzSwowf1SBkVXjj55_VTQGuyeiRqyH05hSU04tY9FJmVtsLdVfViJEZj5e1 sZJ.Ce.hq3DLMXP0l0Qeyheg3VoowMmIe2lGGNilpXor4IC.O5q0yXUHDtot6Tyd5t5q0PBDA7jN ifHgdmgM5GyLiLexuFC8ywG.7lva43E.VP435dItZUtAiuC3A3ZLt.p4YqH4gylvHaQ6G.VgA9Ba UKCLHd.9W7PzojfaE6iNZuve6IPJVr0ZTIfqRFEdMqNWTSZ_jOaaW0e6x.XNwFcsUcxXGdKN0i3U TqXmnSKHa1ufQ3q4ykFBoMAmcHbQ2nwBa_vjDUi823VMMeFd9dw-- Received: from jws10963.mail.sg3.yahoo.com by sendmailws105.mail.sg3.yahoo.com; Mon, 08 Aug 2016 10:30:20 +0000; 1470652220.909 Date: Mon, 8 Aug 2016 10:30:20 +0000 (UTC) From: Om Prakash Jaiswal Reply-To: Om Prakash Jaiswal To: Johan Fredriksson Cc: "pgsql-performance@postgresql.org" , Pgsql-admin , "pgsql-bugs@postgresql.org" Message-ID: <396814634.10139451.1470652220643.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: <1470641200.5646.0.camel@kth.se> References: <521957068.7401317.1470116839414.JavaMail.yahoo.ref@mail.yahoo.com> <521957068.7401317.1470116839414.JavaMail.yahoo@mail.yahoo.com> <1470641200.5646.0.camel@kth.se> Subject: Re: Create language plperlu Error MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10139450_650954085.1470652220640" Content-Length: 4172 X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org ------=_Part_10139450_650954085.1470652220640 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Yes, I have installed postgresql-plperl package.But I am not able to execut= e:create extension plperlcreate language plperlu=20 On Monday, 8 August 2016 12:56 PM, Johan Fredriksson wro= te: =20 =20 > Sir/Madam, > Plateform: RHEL6.5,=C2=A0 Postgresql9.4.0. >=20 >=20 > create extension plperl; >=20 > Create language plperl; >=20 >=20 > I have done following settings: >=20 > Perl version 5.10 > vi /etc/ld.so.conf.d/libperl.conf > /usr/lib/5.10/multi-thread/i386.../CORE/libperl.so > ldconfig >=20 >=20 > ERROR: Can not load "/opt/Postgresql/9.4/lib/postgresql/plperl.so" > undefined symbol Perl_sv_2bool_flags >=20 >=20 > ERROR:=C2=A0 could not load library "/opt/PostgreSQL/9.4/lib/postgresql/p= lperl.so":=20 > /opt/PostgreSQL/9.2/lib/postgresql/plperl.so: undefined symbol: Perl_sv_2= bool_flags >=20 > How do I solve. > Kindly resolve it. >=20 > Regards > Om Prakash Do you have the packet postgresql-plperl installed? =C2=A0 =C2=A0 =C2=A0 =C2=A0 / Eskil ------=_Part_10139450_650954085.1470652220640 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Yes, I have installed postgresql-plperl package.
But I am not able to execute:
create extension = plperl
create= language plperlu


<= div style=3D"display: block;" class=3D"yahoo_quoted">
On Monday, 8 August 2016 12= :56 PM, Johan Fredriksson <eskil@kth.se> wrote:


> Sir/Madam,
> Platefor= m: RHEL6.5,  Postgresql9.4.0.
>
>
> create extension plperl;
&= gt;
> Create language plperl;
> =
>
> I have done following setti= ngs:
>
> Perl version 5.10
> vi /etc/ld.so.conf.d/libperl.conf
> = /usr/lib/5.10/multi-thread/i386.../CORE/libperl.so
> l= dconfig
>
>
&= gt; ERROR: Can not load "/opt/Postgresql/9.4/lib/postgresql/plperl.so"
> undefined symbol Perl_sv_2bool_flags
&= gt;
>
> ERROR:  could not = load library "/opt/PostgreSQL/9.4/lib/postgresql/plperl.so":
> /opt/PostgreSQL/9.2/lib/postgresql/plperl.so: undefined symbol: P= erl_sv_2bool_flags
>
> How do I = solve.
> Kindly resolve it.
> > Regards
> Om Prakash


Do you have the packet postgresql-plperl ins= talled?

        / = Eskil





------=_Part_10139450_650954085.1470652220640--