Обсуждение: BUG #15393: not able to CREATE EXTENSION plperl;

The following bug has been logged on the website:

Bug reference:      15393
Logged by:          ramakrishnan r
Email address:      prakash.ramakrishnan.ap@nielsen.com
PostgreSQL version: 10.4
Operating system:   CENTOS 7.5
Description:

Hi Team,
Am not able to create the Perl extension getting below error.

A4=#  CREATE EXTENSION plperl;
ERROR:  could not load library
"/opt/app/PostgreSQL/10/lib/postgresql/plperl.so":
/opt/app/PostgreSQL/10/lib/postgresql/plperl.so: undefined symbol:
Perl_xs_handshake
A4=# \q


Regards,
Prakash.R
9551559623

=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
> A4=#  CREATE EXTENSION plperl;
> ERROR:  could not load library
> "/opt/app/PostgreSQL/10/lib/postgresql/plperl.so":
> /opt/app/PostgreSQL/10/lib/postgresql/plperl.so: undefined symbol:
> Perl_xs_handshake

I think that your copy of plperl was built against a different version
of Perl than what's present on the box now.  Some googling suggests that
Perl_xs_handshake was added to Perl around version 5.22, so probably
your plperl was built using headers from a later version but the
libperl.so you have is older than that.

            regards, tom lane

Re: PG Bug reporting form 2018-09-20 <153744336902.14986.11179694670889011636@wrigleys.postgresql.org>
> PostgreSQL version: 10.4
> Operating system:   CENTOS 7.5
> /opt/app/PostgreSQL/10/lib/postgresql/plperl.so: undefined symbol:

The packages from yum.postgresql.org should work much better, use
these instead.

Christoph