Re: perl issue

Hi Vignesh,

Am getting below error database up and running only not able to restore the
dump in new cluster in database.

*Util.c: loadable library and perl binaries are mismatched (got handshake
key 0xdb80080, needed 0xde00080)*

*psql.bin:A4_Copy.sql:218: server closed the connection unexpectedly
This probably means the server terminated abnormally before or while
processing the request.psql.bin:A4_Copy.sql:218: connection to server was
lost *

On Wed, Jul 10, 2019 at 5:00 PM vignesh C <vignesh21(at)gmail(dot)com> wrote:

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

--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call
: +91-8939599426