RE: ERROR: could not load library libperl.so, PostgreSQL trying to CREATE EXTENSION plperlu

Alan,

Thank you! Solution: build them from source on the server?
Ben
From: Alan Hodgson [mailto:ahodgson(at)lists(dot)simkin(dot)ca]
Sent: Thursday, November 30, 2017 3:36 PM
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: ERROR: could not load library libperl.so, PostgreSQL trying to CREATE EXTENSION plperlu

On Thu, 2017-11-30 at 22:20 +0000, Ben Nachtrieb wrote:

...to ld.so.conf, I get:
ERROR: could not load library "/var/lib/pgsql10/lib/postgresql/plperl.so": /var/lib/pgsql10/lib/postgresql/plperl.so: undefined symbol: Perl_xs_handshake
SQL state: XX000

It looks to me like your plperl is built against a substantially different version of Perl than what you have installed on the server.

I'd guess you installed a PostgreSQL binary built on a different OS version, or have otherwise mismatched packages.