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