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

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

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

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

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

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

Yes, I have installed postgresql-plperl package.But I am not able to execute:create extension plperlcreate 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

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

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