pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedCreate language plperlu Error
8+ messages / 6 participants
[nested] [flat]
* Create language plperlu Error
@ 2016-08-02 05:47 Om Prakash Jaiswal <op12om@yahoo.co.in>
2016-08-02 06:05 ` Re: Create language plperlu Error John R Pierce <pierce@hogranch.com>
2016-08-02 12:00 ` Re: Create language plperlu Error Luca Ferrari <fluca1978@infinito.it>
2016-08-08 07:26 ` Re: [PERFORM] Create language plperlu Error Johan Fredriksson <eskil@kth.se>
2016-08-08 11:21 ` Re: [PERFORM] Create language plperlu Error Gerardo Herzig <gherzig@fmed.uba.ar>
0 siblings, 4 replies; 8+ messages in thread
From: Om Prakash Jaiswal @ 2016-08-02 05:47 UTC (permalink / raw)
To: pgsql-performance; Pgsql-admin <pgsql-admin@postgresql.org>; pgsql-bugs@postgresql.org <pgsql-bugs@postgresql.org>
Sir/Madam,Plateform: RHEL6.5, Postgresql9.4.0.
create extension plperl;
Create language plperl;
I have done following settings:
Perl version 5.10vi /etc/ld.so.conf.d/libperl.conf/usr/lib/5.10/multi-thread/i386.../CORE/libperl.soldconfig
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Create language plperlu Error
2016-08-02 05:47 Create language plperlu Error Om Prakash Jaiswal <op12om@yahoo.co.in>
@ 2016-08-02 06:05 ` John R Pierce <pierce@hogranch.com>
2016-08-02 06:45 ` Re: Create language plperlu Error Ranjeet Dhumal <jeetu.dhumal@gmail.com>
3 siblings, 1 reply; 8+ messages in thread
From: John R Pierce @ 2016-08-02 06:05 UTC (permalink / raw)
To: pgsql-bugs@postgresql.org
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Create language plperlu Error
2016-08-02 05:47 Create language plperlu Error Om Prakash Jaiswal <op12om@yahoo.co.in>
2016-08-02 06:05 ` Re: Create language plperlu Error John R Pierce <pierce@hogranch.com>
@ 2016-08-02 06:45 ` Ranjeet Dhumal <jeetu.dhumal@gmail.com>
2016-08-02 07:21 ` Re: Create language plperlu Error John R Pierce <pierce@hogranch.com>
0 siblings, 1 reply; 8+ messages in thread
From: Ranjeet Dhumal @ 2016-08-02 06:45 UTC (permalink / raw)
To: John R Pierce <pierce@hogranch.com>; +Cc: pgsql-bugs@postgresql.org
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Create language plperlu Error
2016-08-02 05:47 Create language plperlu Error Om Prakash Jaiswal <op12om@yahoo.co.in>
2016-08-02 06:05 ` Re: Create language plperlu Error John R Pierce <pierce@hogranch.com>
2016-08-02 06:45 ` Re: Create language plperlu Error Ranjeet Dhumal <jeetu.dhumal@gmail.com>
@ 2016-08-02 07:21 ` John R Pierce <pierce@hogranch.com>
0 siblings, 0 replies; 8+ messages in thread
From: John R Pierce @ 2016-08-02 07:21 UTC (permalink / raw)
To: pgsql-bugs@postgresql.org
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Create language plperlu Error
2016-08-02 05:47 Create language plperlu Error Om Prakash Jaiswal <op12om@yahoo.co.in>
@ 2016-08-02 12:00 ` Luca Ferrari <fluca1978@infinito.it>
3 siblings, 0 replies; 8+ messages in thread
From: Luca Ferrari @ 2016-08-02 12:00 UTC (permalink / raw)
To: Om Prakash Jaiswal <op12om@yahoo.co.in>; +Cc: Pgsql-admin <pgsql-admin@postgresql.org>
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [PERFORM] Create language plperlu Error
2016-08-02 05:47 Create language plperlu Error Om Prakash Jaiswal <op12om@yahoo.co.in>
@ 2016-08-08 07:26 ` Johan Fredriksson <eskil@kth.se>
2016-08-08 10:30 ` Re: Create language plperlu Error Om Prakash Jaiswal <op12om@yahoo.co.in>
3 siblings, 1 reply; 8+ messages in thread
From: Johan Fredriksson @ 2016-08-08 07:26 UTC (permalink / raw)
To: Om Prakash Jaiswal <op12om@yahoo.co.in>; +Cc: pgsql-performance; Pgsql-admin <pgsql-admin@postgresql.org>; pgsql-bugs@postgresql.org <pgsql-bugs@postgresql.org>
> 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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Create language plperlu Error
2016-08-02 05:47 Create language plperlu Error Om Prakash Jaiswal <op12om@yahoo.co.in>
2016-08-08 07:26 ` Re: [PERFORM] Create language plperlu Error Johan Fredriksson <eskil@kth.se>
@ 2016-08-08 10:30 ` Om Prakash Jaiswal <op12om@yahoo.co.in>
0 siblings, 0 replies; 8+ messages in thread
From: Om Prakash Jaiswal @ 2016-08-08 10:30 UTC (permalink / raw)
To: Johan Fredriksson <eskil@kth.se>; +Cc: pgsql-performance; Pgsql-admin <pgsql-admin@postgresql.org>; pgsql-bugs@postgresql.org <pgsql-bugs@postgresql.org>
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [PERFORM] Create language plperlu Error
2016-08-02 05:47 Create language plperlu Error Om Prakash Jaiswal <op12om@yahoo.co.in>
@ 2016-08-08 11:21 ` Gerardo Herzig <gherzig@fmed.uba.ar>
3 siblings, 0 replies; 8+ messages in thread
From: Gerardo Herzig @ 2016-08-08 11:21 UTC (permalink / raw)
To: Om Prakash Jaiswal <op12om@yahoo.co.in>; +Cc: pgsql-performance@postgresql.org, Pgsql-admin <pgsql-admin@postgresql.org>; pgsql-bugs@postgresql.org
----- 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
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2016-08-08 11:21 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-08-02 05:47 Create language plperlu Error Om Prakash Jaiswal <op12om@yahoo.co.in>
2016-08-02 06:05 ` John R Pierce <pierce@hogranch.com>
2016-08-02 06:45 ` Ranjeet Dhumal <jeetu.dhumal@gmail.com>
2016-08-02 07:21 ` John R Pierce <pierce@hogranch.com>
2016-08-02 12:00 ` Luca Ferrari <fluca1978@infinito.it>
2016-08-08 07:26 ` Johan Fredriksson <eskil@kth.se>
2016-08-08 10:30 ` Om Prakash Jaiswal <op12om@yahoo.co.in>
2016-08-08 11:21 ` Gerardo Herzig <gherzig@fmed.uba.ar>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox