Re: perl issue

Hi,

You can execute the following command:
ldd /opt/app/PostgreSQL/10/lib/postgresql/plperl.so

This will give you the perl library that it is using.
Then check the perl version that is supported for the installation and the
current perl version that is being used.

You should be able to get an idea of the same.

Regards,
Vignesh
EnterpriseDB: http://www.enterprisedb.com

On Wed, Jul 10, 2019 at 2:53 PM Prakash Ramakrishnan <
prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com> wrote:

> Hi Alvaro,
>
> Thanks This is edb standard edition so please do the needfull how can we
> install the perl here.
>
> Regards,
> Prakash.R
>
> On Wed, Jul 10, 2019 at 4:34 AM Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
> wrote:
>
>> On 2019-Jul-08, Prakash Ramakrishnan wrote:
>>
>> > HI Team ,
>> >
>> > Every time server got rebooted after we getting below perl error anyone
>> > aware of it. please do the needful.
>> >
>> >
>> > *could not load library "/opt/app/PostgreSQL/10/lib/postgresql/plperl.so
>> > /opt/app/PostgreSQL/10/lib/postgresql/plperl.so
>> > undefined symbol: Perl_xs_handshake *
>>
>> Sounds like the perl library does not match the version that your
>> installation was compiled with. It's hard to diagnose with this much
>> data.
>>
>> --
>> Álvaro Herrera https://www.2ndQuadrant.com/
>> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>>
>
>
> --
> Thanks,
> Prakash.R
> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
> call : +91-8939599426
>

--
Regards,
vignesh
Have a nice day