Postgres Pro
Downloads
Home   >   mailing lists

Thread: Create language plperlu Error

Create language plperlu Error

From
Om Prakash Jaiswal
Date:
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


Re: Create language plperlu Error

From
Johan Fredriksson
Date:
> 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

Re: Create language plperlu Error

From
Om Prakash Jaiswal
Date:
Yes, I have installed postgresql-plperl package.
But I am not able to execute:
create extension plperl
create language plperlu


On Monday, 8 August 2016 12:56 PM, Johan Fredriksson <eskil@kth.se> 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.
>
> Regards
> Om Prakash


Do you have the packet postgresql-plperl installed?

        / Eskil





Re: Create language plperlu Error

From
Gerardo Herzig
Date:

----- 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