Date: Thu, 21 Dec 2017 17:06:53 +0000 (UTC)
From: Om Prakash Jaiswal <op12om@yahoo.co.in>
Reply-To: "op12om@yahoo.co.in" <op12om@yahoo.co.in>
To: "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Cc: "santiagocfc@gmail.com" <santiagocfc@gmail.com>,
	=?UTF-8?Q?Devrim_G=C3=BCnd=C3=BCz?= <devrim@gunduz.org>,
	Pgsql-admin <pgsql-admin@postgresql.org>
Message-ID: <620240464.2764068.1513876013697@mail.yahoo.com>
In-Reply-To: <20171221153753.gdhcuupppvchx2td@alvherre.pgsql>
References: <325784998.1478266.1513701114077@mail.yahoo.com>
 <20171221153753.gdhcuupppvchx2td@alvherre.pgsql>
Subject: Re: Couldn't create plperl language
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_Part_2764067_102881530.1513876013697"
Content-Length: 5616
Precedence: bulk

------=_Part_2764067_102881530.1513876013697
Content-Type: multipart/alternative;
	boundary="----=_Part_2764066_2033723252.1513876013606"

------=_Part_2764066_2033723252.1513876013606
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I resolve d the issue by installing same version postgresql rpm and postgre=
sql-plperl.=C2=A0Now it is working.Thanks to all.Om PrakashBangalore

Sent from Yahoo Mail on Android=20
=20
  On Thu, Dec 21, 2017 at 21:08, Alvaro Herrera<alvherre@alvh.no-ip.org> wr=
ote:   Om Prakash Jaiswal wrote:
> I installed RHEL7.3 64 bit is enterprise version.Downloaded postgresql9.6=
.3 64 bit for Linux.Installed in /opt directory.
> RPM -ivh postgresql9.6-plperl96.rpm.Find libperl.so. it was at /usr/lib64=
/perl5/CORE directory.vi /etc/ld.so.conf.d/libperl.conf < /usr/lib64/perl5/=
CORE=C2=A0ldconfig
> vi /etc/ld.so.conf.d/libpostgres.conf</opt/postgres/9.6/lib
> reboot machine.Now=C2=A0create extension plperlu.Error /opt/postgres/9.6/=
lib/postgresql/plperl.so undefined symbol: Perl_save_strlen.

Most likely this indicates that the plperl.so is compiled against a
different version of Perl than the one that provides libperl.so.

I don't understand what you installed (or rather, you did not say), but
I suspect you have a weird (unsupported) combination of packages.

--=20
=C3=81lvaro Herrera=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

 =20

------=_Part_2764066_2033723252.1513876013606
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I resolve d the issue by installing same version postgresql rpm and postgre=
sql-plperl.<div id=3D"yMail_cursorElementTracker_1513875973743">&nbsp;Now i=
t is working.</div><div id=3D"yMail_cursorElementTracker_1513875984574">Tha=
nks to all.</div><div id=3D"yMail_cursorElementTracker_1513875992775">Om Pr=
akash</div><div id=3D"yMail_cursorElementTracker_1513875997574">Bangalore<b=
r><br><div id=3D"ymail_android_signature"><a href=3D"https://overview.mail.=
yahoo.com/mobile/?.src=3DAndroid">Sent from Yahoo Mail on Android</a></div>=
 <br> <blockquote style=3D"margin: 0 0 20px 0;"> <div style=3D"font-family:=
Roboto, sans-serif; color:#6D00F6;"> <div>On Thu, Dec 21, 2017 at 21:08, Al=
varo Herrera</div><div>&lt;alvherre@alvh.no-ip.org&gt; wrote:</div> </div> =
<div style=3D"padding: 10px 0 0 20px; margin: 10px 0 0 0; border-left: 1px =
solid #6D00F6;"> Om Prakash Jaiswal wrote:<div class=3D"yqt2871531947 yQTDB=
ase" id=3D"yqtfd67598"><br clear=3D"none">&gt; I installed RHEL7.3 64 bit i=
s enterprise version.Downloaded postgresql9.6.3 64 bit for Linux.Installed =
in /opt directory.<br clear=3D"none">&gt; RPM -ivh postgresql9.6-plperl96.r=
pm.Find libperl.so. it was at /usr/lib64/perl5/CORE directory.vi /etc/ld.so=
.conf.d/libperl.conf &lt; /usr/lib64/perl5/CORE&nbsp;ldconfig<br clear=3D"n=
one">&gt; vi /etc/ld.so.conf.d/libpostgres.conf&lt;/opt/postgres/9.6/lib<br=
 clear=3D"none">&gt; reboot machine.Now&nbsp;create extension plperlu.Error=
 /opt/postgres/9.6/lib/postgresql/plperl.so undefined symbol: Perl_save_str=
len.</div><br clear=3D"none"><br clear=3D"none">Most likely this indicates =
that the plperl.so is compiled against a<br clear=3D"none">different versio=
n of Perl than the one that provides libperl.so.<br clear=3D"none"><br clea=
r=3D"none">I don't understand what you installed (or rather, you did not sa=
y), but<br clear=3D"none">I suspect you have a weird (unsupported) combinat=
ion of packages.<br clear=3D"none"><br clear=3D"none">-- <br clear=3D"none"=
>=C3=81lvaro Herrera&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=
 <a shape=3D"rect" href=3D"https://www.2ndQuadrant.com/" target=3D"_blank">=
https://www.2ndQuadrant.com/</a><br clear=3D"none">PostgreSQL Development, =
24x7 Support, Remote DBA, Training &amp; Services<div class=3D"yqt287153194=
7 yQTDBase" id=3D"yqtfd32604"><br clear=3D"none"><br clear=3D"none"></div> =
</div> </blockquote></div>
------=_Part_2764066_2033723252.1513876013606--

------=_Part_2764067_102881530.1513876013697
Content-Type: text/plain
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="Untitled"
Content-ID: <1efc905d-1eda-4112-8d6a-ebef33a0dfd3>

T20gUHJha2FzaCBKYWlzd2FsIHdyb3RlOgo+IEkgaW5zdGFsbGVkIFJIRUw3LjMgNjQgYml0IGlz
IGVudGVycHJpc2UgdmVyc2lvbi5Eb3dubG9hZGVkIHBvc3RncmVzcWw5LjYuMyA2NCBiaXQgZm9y
IExpbnV4Lkluc3RhbGxlZCBpbiAvb3B0IGRpcmVjdG9yeS4KPiBSUE0gLWl2aCBwb3N0Z3Jlc3Fs
OS42LXBscGVybDk2LnJwbS5GaW5kIGxpYnBlcmwuc28uIGl0IHdhcyBhdCAvdXNyL2xpYjY0L3Bl
cmw1L0NPUkUgZGlyZWN0b3J5LnZpIC9ldGMvbGQuc28uY29uZi5kL2xpYnBlcmwuY29uZiA8IC91
c3IvbGliNjQvcGVybDUvQ09SRaBsZGNvbmZpZwo+IHZpIC9ldGMvbGQuc28uY29uZi5kL2xpYnBv
c3RncmVzLmNvbmY8L29wdC9wb3N0Z3Jlcy85LjYvbGliCj4gcmVib290IG1hY2hpbmUuTm93oGNy
ZWF0ZSBleHRlbnNpb24gcGxwZXJsdS5FcnJvciAvb3B0L3Bvc3RncmVzLzkuNi9saWIvcG9zdGdy
ZXNxbC9wbHBlcmwuc28gdW5kZWZpbmVkIHN5bWJvbDogUGVybF9zYXZlX3N0cmxlbi4KCk1vc3Qg
bGlrZWx5IHRoaXMgaW5kaWNhdGVzIHRoYXQgdGhlIHBscGVybC5zbyBpcyBjb21waWxlZCBhZ2Fp
bnN0IGEKZGlmZmVyZW50IHZlcnNpb24gb2YgUGVybCB0aGFuIHRoZSBvbmUgdGhhdCBwcm92aWRl
cyBsaWJwZXJsLnNvLgoKSSBkb24ndCB1bmRlcnN0YW5kIHdoYXQgeW91IGluc3RhbGxlZCAob3Ig
cmF0aGVyLCB5b3UgZGlkIG5vdCBzYXkpLCBidXQKSSBzdXNwZWN0IHlvdSBoYXZlIGEgd2VpcmQg
KHVuc3VwcG9ydGVkKSBjb21iaW5hdGlvbiBvZiBwYWNrYWdlcy4KCi0tIArBbHZhcm8gSGVycmVy
YSAgICAgICAgICAgICAgICBodHRwczovL3d3dy4ybmRRdWFkcmFudC5jb20vClBvc3RncmVTUUwg
RGV2ZWxvcG1lbnQsIDI0eDcgU3VwcG9ydCwgUmVtb3RlIERCQSwgVHJhaW5pbmcgJiBTZXJ2aWNl
cwoK

------=_Part_2764067_102881530.1513876013697--