pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Couldn't create plperl language
6+ messages / 4 participants
[nested] [flat]

* Couldn't create plperl language
@ 2017-12-19 10:25  Om Prakash Jaiswal <op12om@yahoo.co.in>
  0 siblings, 1 reply; 6+ messages in thread

From: Om Prakash Jaiswal @ 2017-12-19 10:25 UTC (permalink / raw)
  To: pgsql-admin

I am creating plperl language on postgres 9.6 64 bit RHEL7.I am getting error undefined symbol: perl_save_strlen. How to resolve it?Kindly help me.I installed postgresql9.6-plperl96.I also linked plperl.so with libperl.so.
How should I solve it.
Regards Om PrakashBangalore.

Sent from Yahoo Mail on Android

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Couldn't create plperl language
@ 2017-12-19 12:09  Devrim Gündüz <devrim@gunduz.org>
  parent: Om Prakash Jaiswal <op12om@yahoo.co.in>
  0 siblings, 1 reply; 6+ messages in thread

From: Devrim Gündüz @ 2017-12-19 12:09 UTC (permalink / raw)
  To: op12om@yahoo.co.in <op12om@yahoo.co.in>; Om Prakash Jaiswal <op12om@yahoo.co.in>; pgsql-admin

Hi,

How did you install PostgreSQL? OS packages, community RPMs, installers, etc.?

Regards, Devrim

On 19 December 2017 13:25:35 GMT+03:00, Om Prakash Jaiswal <op12om@yahoo.co.in> wrote:
>I am creating plperl language on postgres 9.6 64 bit RHEL7.I am getting
>error undefined symbol: perl_save_strlen. How to resolve it?Kindly help
>me.I installed postgresql9.6-plperl96.I also linked plperl.so with
>libperl.so.
>How should I solve it.
>Regards Om PrakashBangalore.
>
>Sent from Yahoo Mail on Android

-- 
Sent from my Android device with K-9 Mail. 

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Couldn't create plperl language
@ 2017-12-19 12:36  Francis Santiago <santiagocfc@gmail.com>
  parent: Devrim Gündüz <devrim@gunduz.org>
  0 siblings, 1 reply; 6+ messages in thread

From: Francis Santiago @ 2017-12-19 12:36 UTC (permalink / raw)
  To: Devrim Gündüz <devrim@gunduz.org>; +Cc: op12om@yahoo.co.in <op12om@yahoo.co.in>; pgsql-admin

Hi, you can send the error

2017-12-19 9:09 GMT-03:00 Devrim Gündüz <devrim@gunduz.org>:

> Hi,
>
> How did you install PostgreSQL? OS packages, community RPMs, installers,
> etc.?
>
> Regards, Devrim
>
>
> On 19 December 2017 13:25:35 GMT+03:00, Om Prakash Jaiswal <
> op12om@yahoo.co.in> wrote:
>>
>> I am creating plperl language on postgres 9.6 64 bit RHEL7.
>> I am getting error undefined symbol: perl_save_strlen. How to resolve it?
>> Kindly help me.
>> I installed postgresql9.6-plperl96.
>> I also linked plperl.so with libperl.so.
>>
>> How should I solve it.
>>
>> Regards
>> Om Prakash
>> Bangalore.
>>
>> Sent from Yahoo Mail on Android
>> <https://overview.mail.yahoo.com/mobile/?.src=Android;
>>
>
> --
> Sent from my Android device with K-9 Mail.
>

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Couldn't create plperl language
@ 2017-12-19 16:31  Om Prakash Jaiswal <op12om@yahoo.co.in>
  parent: Francis Santiago <santiagocfc@gmail.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Om Prakash Jaiswal @ 2017-12-19 16:31 UTC (permalink / raw)
  To: santiagocfc@gmail.com <santiagocfc@gmail.com>; Devrim Gündüz <devrim@gunduz.org>; +Cc: pgsql-admin

I installed RHEL7.3 64 bit is enterprise version.Downloaded postgresql9.6.3 64 bit for Linux.Installed in /opt directory.
RPM -ivh postgresql9.6-plperl96.rpm.Find libperl.so. it was at /usr/lib64/perl5/CORE directory.vi /etc/ld.so.conf.d/libperl.conf < /usr/lib64/perl5/CORE ldconfig
vi /etc/ld.so.conf.d/libpostgres.conf</opt/postgres/9.6/lib
reboot machine.Now create extension plperlu.Error /opt/postgres/9.6/lib/postgresql/plperl.so undefined symbol: Perl_save_strlen.
Sent from Yahoo Mail on Android 
 
  On Tue, Dec 19, 2017 at 18:07, Francis Santiago<santiagocfc@gmail.com> wrote:   Hi, you can send the error

2017-12-19 9:09 GMT-03:00 Devrim Gündüz <devrim@gunduz.org>:

Hi,

How did you install PostgreSQL? OS packages, community RPMs, installers, etc.?

Regards, Devrim

On 19 December 2017 13:25:35 GMT+03:00, Om Prakash Jaiswal <op12om@yahoo.co.in> wrote:
I am creating plperl language on postgres 9.6 64 bit RHEL7.I am getting error undefined symbol: perl_save_strlen. How to resolve it?Kindly help me.I installed postgresql9.6-plperl96.I also linked plperl.so with libperl.so.
How should I solve it.
Regards Om PrakashBangalore.

Sent from Yahoo Mail on Android

-- 
Sent from my Android device with K-9 Mail. 





  

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Couldn't create plperl language
@ 2017-12-21 15:37  Alvaro Herrera <alvherre@alvh.no-ip.org>
  parent: Om Prakash Jaiswal <op12om@yahoo.co.in>
  0 siblings, 1 reply; 6+ messages in thread

From: Alvaro Herrera @ 2017-12-21 15:37 UTC (permalink / raw)
  To: op12om@yahoo.co.in <op12om@yahoo.co.in>; +Cc: santiagocfc@gmail.com <santiagocfc@gmail.com>; Devrim Gündüz <devrim@gunduz.org>; pgsql-admin

Om Prakash Jaiswal wrote:
> I installed RHEL7.3 64 bit is enterprise version.Downloaded postgresql9.6.3 64 bit for Linux.Installed in /opt directory.
> RPM -ivh postgresql9.6-plperl96.rpm.Find libperl.so. it was at /usr/lib64/perl5/CORE directory.vi /etc/ld.so.conf.d/libperl.conf < /usr/lib64/perl5/CORE ldconfig
> vi /etc/ld.so.conf.d/libpostgres.conf</opt/postgres/9.6/lib
> reboot machine.Now create extension plperlu.Error /opt/postgres/9.6/lib/postgresql/plperl.so undefined symbol: Perl_save_strlen.

Most likely this indicates that the plperl.so is compiled against a
different version of Perl than the one that provides libperl.so.

I don't understand what you installed (or rather, you did not say), but
I suspect you have a weird (unsupported) combination of packages.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Couldn't create plperl language
@ 2017-12-21 17:06  Om Prakash Jaiswal <op12om@yahoo.co.in>
  parent: Alvaro Herrera <alvherre@alvh.no-ip.org>
  0 siblings, 0 replies; 6+ messages in thread

From: Om Prakash Jaiswal @ 2017-12-21 17:06 UTC (permalink / raw)
  To: alvherre@alvh.no-ip.org <alvherre@alvh.no-ip.org>; +Cc: santiagocfc@gmail.com <santiagocfc@gmail.com>; Devrim Gündüz <devrim@gunduz.org>; pgsql-admin

I resolve d the issue by installing same version postgresql rpm and postgresql-plperl. Now it is working.Thanks to all.Om PrakashBangalore

Sent from Yahoo Mail on Android 
 
  On Thu, Dec 21, 2017 at 21:08, Alvaro Herrera<alvherre@alvh.no-ip.org> wrote:   Om Prakash Jaiswal wrote:
> I installed RHEL7.3 64 bit is enterprise version.Downloaded postgresql9.6.3 64 bit for Linux.Installed in /opt directory.
> RPM -ivh postgresql9.6-plperl96.rpm.Find libperl.so. it was at /usr/lib64/perl5/CORE directory.vi /etc/ld.so.conf.d/libperl.conf < /usr/lib64/perl5/CORE ldconfig
> vi /etc/ld.so.conf.d/libpostgres.conf</opt/postgres/9.6/lib
> reboot machine.Now create extension plperlu.Error /opt/postgres/9.6/lib/postgresql/plperl.so undefined symbol: Perl_save_strlen.

Most likely this indicates that the plperl.so is compiled against a
different version of Perl than the one that provides libperl.so.

I don't understand what you installed (or rather, you did not say), but
I suspect you have a weird (unsupported) combination of packages.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

  

Attachments:

Untitled (text/plain, 915B) download Om Prakash Jaiswal wrote: > I installed RHEL7.3 64 bit is enterprise version.Downloaded postgresql9.6.3 64 bit for Linux.Installed in /opt directory. > RPM -ivh postgresql9.6-plperl96.rpm.Find libperl.so. it was at /usr/lib64/perl5/CORE directory.vi /etc/ld.so.conf.d/libperl.conf < /usr/lib64/perl5/CORE ldconfig > vi /etc/ld.so.conf.d/libpostgres.conf</opt/postgres/9.6/lib > reboot machine.Now create extension plperlu.Error /opt/postgres/9.6/lib/postgresql/plperl.so undefined symbol: Perl_save_strlen. Most likely this indicates that the plperl.so is compiled against a different version of Perl than the one that provides libperl.so. I don't understand what you installed (or rather, you did not say), but I suspect you have a weird (unsupported) combination of packages. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 6+ messages in thread


end of thread, other threads:[~2017-12-21 17:06 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-12-19 10:25 Couldn't create plperl language Om Prakash Jaiswal <op12om@yahoo.co.in>
2017-12-19 12:09 ` Devrim Gündüz <devrim@gunduz.org>
2017-12-19 12:36   ` Francis Santiago <santiagocfc@gmail.com>
2017-12-19 16:31     ` Om Prakash Jaiswal <op12om@yahoo.co.in>
2017-12-21 15:37       ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2017-12-21 17:06         ` Om Prakash Jaiswal <op12om@yahoo.co.in>

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