Обсуждение: Couldn't create plperl language
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
Hi,
How did you install PostgreSQL? OS packages, community RPMs, installers, etc.?
Regards, Devrim
--
Sent from my Android device with K-9 Mail.
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.RegardsOm Prakash
--
Sent from my Android device with K-9 Mail.
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.RegardsOm Prakash
Sent from my Android device with K-9 Mail.
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 error2017-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.RegardsOm Prakash
Sent from my Android device with K-9 Mail.
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
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