Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bUSq2-0001UR-Co for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Aug 2016 06:06:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bUSq1-0002Z1-7E for pgsql-bugs@arkaria.postgresql.org; Tue, 02 Aug 2016 06:06:01 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bUSpN-0001h9-9r for pgsql-bugs@postgresql.org; Tue, 02 Aug 2016 06:05:21 +0000 Received: from hogranch.com ([75.101.82.47]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bUSpG-0000aW-6G for pgsql-bugs@postgresql.org; Tue, 02 Aug 2016 06:05:20 +0000 Received: from [192.168.0.2] (porker [192.168.0.2]) by hogranch.com (8.11.6/8.11.6) with ESMTP id u72655v10433 for ; Mon, 1 Aug 2016 23:05:05 -0700 Subject: Re: Create language plperlu Error To: pgsql-bugs@postgresql.org References: <521957068.7401317.1470116839414.JavaMail.yahoo.ref@mail.yahoo.com> <521957068.7401317.1470116839414.JavaMail.yahoo@mail.yahoo.com> From: John R Pierce Message-ID: <47989faf-44cf-7710-5447-d3a1c816facf@hogranch.com> Date: Mon, 1 Aug 2016 23:05:08 -0700 User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.2.0 MIME-Version: 1.0 In-Reply-To: <521957068.7401317.1470116839414.JavaMail.yahoo@mail.yahoo.com> Content-Type: multipart/alternative; boundary="------------ACAD66650F0456139A97537B" X-HawgScanner-Information: Please contact the ISP for more information X-HawgScanner: Found to be clean X-Pg-Spam-Score: -3.1 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org This is a multi-part message in MIME format. --------------ACAD66650F0456139A97537B Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit On 8/1/2016 10:47 PM, Om Prakash Jaiswal wrote: > Sir/Madam, > Plateform: RHEL6.5, Postgresql9.4.0. > > create extension plperl; > Create language plperl; > > I have done following settings: > Perl version 5.10 > vi /etc/ld.so.conf.d/libperl.conf > /usr/lib/5.10/multi-thread/i386.../CORE/libperl.so > ldconfig > > ERROR: Can not load "/opt/Postgresql/9.4/lib/postgresql/plperl.so" > undefined symbol Perl_sv_2bool_flags > > |ERROR:could notload library > "/opt/PostgreSQL/9.4/lib/postgresql/plperl.so":/opt/PostgreSQL/9.2/lib/postgresql/plperl.so:undefinedsymbol:Perl_sv_2bool_flags > How do I solve. Kindly resolve it. | /opt suggests you're running the EnterpriseDB installation of Postgresql. I would instead use the RPM distribution from http://yum.postgresql.org, this integrates just fine with plperl, plpython, etc on redhat and centos and other similar platforms. btw, RHEL 6.5 is several years behind in security updates, I believe 6.8 is the current update, you really should update. ditto, PostgreSQL 9.4.0 is long superseded, current 9.4 version is 9.4.8 -- john r pierce, recycling bits in santa cruz --------------ACAD66650F0456139A97537B Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 PGh0bWw+DQogIDxoZWFkPg0KICAgIDxtZXRhIGNvbnRlbnQ9InRleHQvaHRtbDsgY2hhcnNl dD11dGYtOCIgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIj4NCiAgPC9oZWFkPg0KICA8Ym9k eSBiZ2NvbG9yPSIjRkZGRkZGIiB0ZXh0PSIjMDAwMDAwIj4NCiAgICA8ZGl2IGNsYXNzPSJt b3otY2l0ZS1wcmVmaXgiPk9uIDgvMS8yMDE2IDEwOjQ3IFBNLCBPbSBQcmFrYXNoDQogICAg ICBKYWlzd2FsIHdyb3RlOjxicj4NCiAgICA8L2Rpdj4NCiAgICA8YmxvY2txdW90ZQ0KICAg ICAgY2l0ZT0ibWlkOjUyMTk1NzA2OC43NDAxMzE3LjE0NzAxMTY4Mzk0MTQuSmF2YU1haWwu eWFob29AbWFpbC55YWhvby5jb20iDQogICAgICB0eXBlPSJjaXRlIj4NCiAgICAgIDxkaXYg aWQ9Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAxMTYwNzY2MTdfNzM2MyI+U2lyL01hZGFtLDwv ZGl2Pg0KICAgICAgPGRpdiBkaXI9Imx0ciIgaWQ9Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAx MTYwNzY2MTdfNzYwNCI+UGxhdGVmb3JtOg0KICAgICAgICBSSEVMNi41LMKgIFBvc3RncmVz cWw5LjQuMC48L2Rpdj4NCiAgICAgIDxkaXYgaWQ9Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAx MTYwNzY2MTdfNzg5MyIgZGlyPSJsdHIiPjxicj4NCiAgICAgIDwvZGl2Pg0KICAgICAgPGRp diBpZD0ieXVpXzNfMTZfMF95bTE5XzFfMTQ3MDExNjA3NjYxN183NjIyIj5jcmVhdGUgZXh0 ZW5zaW9uDQogICAgICAgIHBscGVybDs8YnI+DQogICAgICA8L2Rpdj4NCiAgICAgIDxkaXYg aWQ9Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAxMTYwNzY2MTdfNzYyMCI+Q3JlYXRlIGxhbmd1 YWdlDQogICAgICAgIHBscGVybDs8L2Rpdj4NCiAgICAgIDxkaXYgaWQ9Inl1aV8zXzE2XzBf eW0xOV8xXzE0NzAxMTYwNzY2MTdfNzY0MSI+PGJyPg0KICAgICAgPC9kaXY+DQogICAgICA8 ZGl2IGlkPSJ5dWlfM18xNl8wX3ltMTlfMV8xNDcwMTE2MDc2NjE3Xzc4NjMiPkkgaGF2ZSBk b25lDQogICAgICAgIGZvbGxvd2luZyBzZXR0aW5nczo8YnI+DQogICAgICA8L2Rpdj4NCiAg ICAgIDxkaXYgaWQ9Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAxMTYwNzY2MTdfNzcyMiI+UGVy bCB2ZXJzaW9uIDUuMTA8L2Rpdj4NCiAgICAgIDxkaXYgaWQ9Inl1aV8zXzE2XzBfeW0xOV8x XzE0NzAxMTYwNzY2MTdfNzcyMyIgZGlyPSJsdHIiPnZpDQogICAgICAgIC9ldGMvbGQuc28u Y29uZi5kL2xpYnBlcmwuY29uZjwvZGl2Pg0KICAgICAgPGRpdiBpZD0ieXVpXzNfMTZfMF95 bTE5XzFfMTQ3MDExNjA3NjYxN183NzI0IiBkaXI9Imx0ciI+L3Vzci9saWIvNS4xMC9tdWx0 aS10aHJlYWQvaTM4Ni4uLi9DT1JFL2xpYnBlcmwuc288L2Rpdj4NCiAgICAgIDxkaXYgaWQ9 Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAxMTYwNzY2MTdfNzcyNSIgZGlyPSJsdHIiPmxkY29u ZmlnPC9kaXY+DQogICAgICA8ZGl2IGlkPSJ5dWlfM18xNl8wX3ltMTlfMV8xNDcwMTE2MDc2 NjE3Xzc3MjciIGRpcj0ibHRyIj48YnI+DQogICAgICA8L2Rpdj4NCiAgICAgIDxkaXYgaWQ9 Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAxMTYwNzY2MTdfNzcyNiIgZGlyPSJsdHIiPkVSUk9S Og0KICAgICAgICBDYW4gbm90IGxvYWQgIi9vcHQvUG9zdGdyZXNxbC85LjQvbGliL3Bvc3Rn cmVzcWwvcGxwZXJsLnNvIg0KICAgICAgICB1bmRlZmluZWQgc3ltYm9sIFBlcmxfc3ZfMmJv b2xfZmxhZ3M8L2Rpdj4NCiAgICAgIDxkaXYgaWQ9Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAx MTYwNzY2MTdfNzc1MiIgZGlyPSJsdHIiPjxicj4NCiAgICAgIDwvZGl2Pg0KICAgICAgPHBy ZSBpZD0ieXVpXzNfMTZfMF95bTE5XzFfMTQ3MDExNjA3NjYxN183ODEyIiBzdHlsZT0iIj48 Y29kZSBpZD0ieXVpXzNfMTZfMF95bTE5XzFfMTQ3MDExNjA3NjYxN183ODEzIj48c3BhbiBp ZD0ieXVpXzNfMTZfMF95bTE5XzFfMTQ3MDExNjA3NjYxN183ODE0Ij5FUlJPUjwvc3Bhbj48 c3BhbiBpZD0ieXVpXzNfMTZfMF95bTE5XzFfMTQ3MDExNjA3NjYxN183ODE1Ij46PC9zcGFu PjxzcGFuIGlkPSJ5dWlfM18xNl8wX3ltMTlfMV8xNDcwMTE2MDc2NjE3Xzc4MTYiPiAgY291 bGQgPC9zcGFuPjxzcGFuIGlkPSJ5dWlfM18xNl8wX3ltMTlfMV8xNDcwMTE2MDc2NjE3Xzc4 MTciPm5vdDwvc3Bhbj48c3BhbiBpZD0ieXVpXzNfMTZfMF95bTE5XzFfMTQ3MDExNjA3NjYx N183ODE4Ij4gbG9hZCBsaWJyYXJ5IDwvc3Bhbj48c3BhbiBpZD0ieXVpXzNfMTZfMF95bTE5 XzFfMTQ3MDExNjA3NjYxN183ODE5Ij4iL29wdC9Qb3N0Z3JlU1FMLzkuNC9saWIvcG9zdGdy ZXNxbC9wbHBlcmwuc28iPC9zcGFuPjxzcGFuIGlkPSJ5dWlfM18xNl8wX3ltMTlfMV8xNDcw MTE2MDc2NjE3Xzc4MjAiPjo8L3NwYW4+PHNwYW4gaWQ9Inl1aV8zXzE2XzBfeW0xOV8xXzE0 NzAxMTYwNzY2MTdfNzgyMSI+IA0KPC9zcGFuPjxzcGFuIGlkPSJ5dWlfM18xNl8wX3ltMTlf MV8xNDcwMTE2MDc2NjE3Xzc4MjIiPi9vcHQvPC9zcGFuPjxzcGFuIGlkPSJ5dWlfM18xNl8w X3ltMTlfMV8xNDcwMTE2MDc2NjE3Xzc4MjMiPlBvc3RncmVTUUw8L3NwYW4+PHNwYW4gaWQ9 Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAxMTYwNzY2MTdfNzgyNCI+Lzwvc3Bhbj48c3BhbiBp ZD0ieXVpXzNfMTZfMF95bTE5XzFfMTQ3MDExNjA3NjYxN183ODI1Ij45LjI8L3NwYW4+PHNw YW4gaWQ9Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAxMTYwNzY2MTdfNzgyNiI+Lzwvc3Bhbj48 c3BhbiBpZD0ieXVpXzNfMTZfMF95bTE5XzFfMTQ3MDExNjA3NjYxN183ODI3Ij5saWI8L3Nw YW4+PHNwYW4gaWQ9Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAxMTYwNzY2MTdfNzgyOCI+Lzwv c3Bhbj48c3BhbiBpZD0ieXVpXzNfMTZfMF95bTE5XzFfMTQ3MDExNjA3NjYxN183ODI5Ij5w b3N0Z3Jlc3FsPC9zcGFuPjxzcGFuIGlkPSJ5dWlfM18xNl8wX3ltMTlfMV8xNDcwMTE2MDc2 NjE3Xzc4MzAiPi88L3NwYW4+PHNwYW4gaWQ9Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAxMTYw NzY2MTdfNzgzMSI+cGxwZXJsPC9zcGFuPjxzcGFuIGlkPSJ5dWlfM18xNl8wX3ltMTlfMV8x NDcwMTE2MDc2NjE3Xzc4MzIiPi48L3NwYW4+PHNwYW4gaWQ9Inl1aV8zXzE2XzBfeW0xOV8x XzE0NzAxMTYwNzY2MTdfNzgzMyI+c288L3NwYW4+PHNwYW4gaWQ9Inl1aV8zXzE2XzBfeW0x OV8xXzE0NzAxMTYwNzY2MTdfNzgzNCI+Ojwvc3Bhbj48c3BhbiBpZD0ieXVpXzNfMTZfMF95 bTE5XzFfMTQ3MDExNjA3NjYxN183ODM1Ij4gPC9zcGFuPjxzcGFuIGlkPSJ5dWlfM18xNl8w X3ltMTlfMV8xNDcwMTE2MDc2NjE3Xzc4MzYiPnVuZGVmaW5lZDwvc3Bhbj48c3BhbiBpZD0i eXVpXzNfMTZfMF95bTE5XzFfMTQ3MDExNjA3NjYxN183ODM3Ij4gc3ltYm9sPC9zcGFuPjxz cGFuIGlkPSJ5dWlfM18xNl8wX3ltMTlfMV8xNDcwMTE2MDc2NjE3Xzc4MzgiPjo8L3NwYW4+ PHNwYW4gaWQ9Inl1aV8zXzE2XzBfeW0xOV8xXzE0NzAxMTYwNzY2MTdfNzgzOSI+IDwvc3Bh bj48c3BhbiBpZD0ieXVpXzNfMTZfMF95bTE5XzFfMTQ3MDExNjA3NjYxN183ODQwIj5QZXJs X3N2XzJib29sX2ZsYWdzDQoNCkhvdyBkbyBJIHNvbHZlLg0KS2luZGx5IHJlc29sdmUgaXQu DQo8L3NwYW4+PC9jb2RlPjwvcHJlPg0KICAgIDwvYmxvY2txdW90ZT4NCiAgICA8YnI+DQog ICAgPHA+L29wdCBzdWdnZXN0cyB5b3UncmUgcnVubmluZyB0aGUgRW50ZXJwcmlzZURCIGlu c3RhbGxhdGlvbiBvZg0KICAgICAgUG9zdGdyZXNxbC7CoCBJIHdvdWxkIGluc3RlYWQgdXNl IHRoZSBSUE0gZGlzdHJpYnV0aW9uIGZyb20NCiAgICAgIDxhIGNsYXNzPSJtb3otdHh0LWxp bmstZnJlZXRleHQiIGhyZWY9Imh0dHA6Ly95dW0ucG9zdGdyZXNxbC5vcmciPmh0dHA6Ly95 dW0ucG9zdGdyZXNxbC5vcmc8L2E+LCB0aGlzIGludGVncmF0ZXMganVzdCBmaW5lIHdpdGgg cGxwZXJsLA0KICAgICAgcGxweXRob24sIGV0YyBvbiByZWRoYXQgYW5kIGNlbnRvcyBhbmQg b3RoZXIgc2ltaWxhciBwbGF0Zm9ybXMuPC9wPg0KICAgIDxwPmJ0dywgUkhFTCA2LjUgaXMg c2V2ZXJhbCB5ZWFycyBiZWhpbmQgaW4gc2VjdXJpdHkgdXBkYXRlcywgSQ0KICAgICAgYmVs aWV2ZSA2LjggaXMgdGhlIGN1cnJlbnQgdXBkYXRlLCB5b3UgcmVhbGx5IHNob3VsZCB1cGRh dGUuPC9wPg0KICAgIDxwPmRpdHRvLCBQb3N0Z3JlU1FMIDkuNC4wIGlzIGxvbmcgc3VwZXJz ZWRlZCwgY3VycmVudCA5LjQgdmVyc2lvbg0KICAgICAgaXMgOS40Ljg8L3A+DQogICAgPHA+ PGJyPg0KICAgIDwvcD4NCiAgICA8cHJlIGNsYXNzPSJtb3otc2lnbmF0dXJlIiBjb2xzPSI3 MiI+LS0gDQpqb2huIHIgcGllcmNlLCByZWN5Y2xpbmcgYml0cyBpbiBzYW50YSBjcnV6PC9w cmU+DQogIDwvYm9keT4NCjwvaHRtbD4NCg== --------------ACAD66650F0456139A97537B--