Thread: Couldn't create plperl language

On Tue, Dec 19, 2017 at 18:07, Francis Santiago

<santiagocfc@gmail.com> wrote:

Hi, you can send the error

2017-12-19 9:09 GMT-03:00 Devrim Gündüz <devrim@gunduz.org>:

Hi,

How did you install PostgreSQL? OS packages, community RPMs, installers, etc.?

Regards, Devrim

On 19 December 2017 13:25:35 GMT+03:00, Om Prakash Jaiswal <op12om@yahoo.co.in> wrote:

I am creating plperl language on postgres 9.6 64 bit RHEL7.

I am getting error undefined symbol: perl_save_strlen. How to resolve it?

Kindly help me.

I installed postgresql9.6-plperl96.

I also linked plperl.so with libperl.so.

How should I solve it.

Regards 

Om Prakash

Bangalore.

Sent from Yahoo Mail on Android

--
Sent from my Android device with K-9 Mail.

On Thu, Dec 21, 2017 at 21:08, Alvaro Herrera

<alvherre@alvh.no-ip.org> wrote:

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 ldconfig
> vi /etc/ld.so.conf.d/libpostgres.conf</opt/postgres/9.6/lib
> reboot machine.Now create 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.

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services