Обсуждение: Create language plperlu Error

On 8/1/2016 10:47 PM, Om Prakash Jaiswal wrote:
> 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 notload library
>
"/opt/PostgreSQL/9.4/lib/postgresql/plperl.so":/opt/PostgreSQL/9.2/lib/postgresql/plperl.so:undefinedsymbol:Perl_sv_2bool_flags

> How do I solve. Kindly resolve it. |

/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

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.



On 2 August 2016 at 11:35, John R Pierce <pierce@hogranch.com> wrote:

> On 8/1/2016 10:47 PM, Om Prakash Jaiswal wrote:
>
> 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.
>
>
> /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
>
>


--
--Regards
  Ranjeet  R. Dhumal

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

> 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

Do you have the packet postgresql-plperl installed?

        / Eskil

----- Mensaje original -----
> De: "Om Prakash Jaiswal" <op12om@yahoo.co.in>
> Para: pgsql-performance@postgresql.org, "Pgsql-admin" <pgsql-admin@postgresql.org>, pgsql-bugs@postgresql.org
> Enviados: Martes, 2 de Agosto 2016 2:47:19
> Asunto: [PERFORM] Create language plperlu Error
>
>
>
> 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.
>

I think your 9.4 is using the 9.2 version of the plperl.so library. Maybe you should recompile.

HTH
Gerardo