Обсуждение: Couldn't create plperl language

Поиск
Список
Период
Сортировка

Couldn't create plperl language

От
Om Prakash Jaiswal
Дата:
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

Re: Couldn't create plperl language

От
Devrim Gündüz
Дата:
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

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

Re: Couldn't create plperl language

От
Francis Santiago
Дата:
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

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




Re: Couldn't create plperl language

От
Om Prakash Jaiswal
Дата:
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.


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

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




Re: Couldn't create plperl language

От
Alvaro Herrera
Дата:
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


Re: Couldn't create plperl language

От
Om Prakash Jaiswal
Дата:
I resolve d the issue by installing same version postgresql rpm and postgresql-plperl.
 Now it is working.
Thanks to all.
Om Prakash
Bangalore


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


Вложения