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

Поиск
Список
Период
Сортировка

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


Re: Create language plperlu Error

От
Luca Ferrari
Дата:
On Tue, Aug 2, 2016 at 7:47 AM, Om Prakash Jaiswal <op12om@yahoo.co.in> wrote:
> 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

Seems to me you are running a Perl version compiled with different
options than those expected from PostgreSQL. How do you install perl
and dependencies?
Have you compiled it (or PostgreSQL)?

By the way, spreading your message around several mailing list,
especially not related to your problem, is the right way to get your
message ignored.

Luca

Re: [PERFORM] Create language plperlu Error

От
Johan Fredriksson
Дата:
> 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: [PERFORM] Create language plperlu Error

От
Om Prakash Jaiswal
Дата:
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: [PERFORM] Create language plperlu Error

От
Gerardo Herzig
Дата:

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