[BUGS] Create language plperlu Error

[Om Prakash Jaiswal]

Sir/Madam,

Plateform: RHEL6.5,  Postgresql9.4.0.

create extension plperl;

Create language plperl;

I have done following settings:

Perl version 5.10

vi /etc/ld.so.conf.d/libperl.conf

/usr/lib/5.10/multi-thread/i386.../CORE/libperl.so

ldconfig

ERROR: Can not load "/opt/Postgresql/9.4/lib/postgresql/plperl.so" undefined symbol Perl_sv_2bool_flags

ERROR:  could not load library "/opt/PostgreSQL/9.4/lib/postgresql/plperl.so": 
/opt/PostgreSQL/9.2/lib/postgresql/plperl.so: undefined symbol: Perl_sv_2bool_flags

How do I solve.
Kindly resolve it.

Regards
Om Prakash

[John R Pierce]

/opt suggests you're running the EnterpriseDB installation of Postgresql.  I would instead use the RPM distribution from http://yum.postgresql.org, this integrates just fine with plperl, plpython, etc on redhat and centos and other similar platforms.

btw, RHEL 6.5 is several years behind in security updates, I believe 6.8 is the current update, you really should update.

ditto, PostgreSQL 9.4.0 is long superseded, current 9.4 version is 9.4.8

-- 
john r pierce, recycling bits in santa cruz

[Ranjeet Dhumal]

Hi Prakash,

In addition to John's update,

What plperl.so is telling you that one of its symbols is undefined. This may be due to compile options or may means you need a newer version of Perl and libperl.so (5.10.1 is quite old). Recent versions of PotgreSQL and plperl usually require a newer version of perl than the one you cite.

So try using perl 5.14 and greater which contains Perl_sv_2bool_flags.

--

--Regards
  Ranjeet  R. Dhumal
 

[John R Pierce]

On 8/1/2016 11:45 PM, Ranjeet Dhumal wrote:
>
> What plperl.so is telling you that one of its symbols is undefined.
> This may be due to compile options or may means you need a newer
> version of Perl and libperl.so (5.10.1 is quite old). Recent versions
> of PotgreSQL and plperl usually require a newer version of perl than
> the one you cite.
>
> So try using perl 5.14 and greater which contains Perl_sv_2bool_flags.

RHEL 6 has perl 5.10.1, you don't update it. you could install a
newer perl in a different location but its pretty unlikely the postgres
stuff would use it as-is.

the PGDG rpm distributions are built to use the appropriate system
perl. I don't know what enterprisedb is building their /opt/postgres
to use.

--
john r pierce, recycling bits in santa cruz



--

Sent via pgsql-bugs mailing list (pgsql...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs