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