Alan, Thank you! Solution: build them from source on the server? Ben From: Alan Hodgson [mailto:ahodg...@lists.simkin.ca] Sent: Thursday, November 30, 2017 3:36 PM To: pgsql-general <pgsql-general@lists.postgresql.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.