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

From: Ben Nachtrieb <bnachtrieb(at)crescat(dot)net>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Cc: Ben Nachtrieb <bnachtrieb(at)crescat(dot)net>
Subject: ERROR: could not load library libperl.so, PostgreSQL trying to CREATE EXTENSION plperlu
Date: 2017-11-30 22:20:53
Message-ID: BN6PR1301MB22122CA7D19050FC54C23C09D4380@BN6PR1301MB2212.namprd13.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I want to use the perl language in a postgres function.

I am attempting to:
CREATE EXTENSION plperlu

...via pgAdmin 4 connected to postgres 10 and I get this error:
ERROR: could not load library "/var/lib/pgsql10/lib/postgresql/plperl.so": libperl.so: cannot open shared object file: No such file or directory
SQL state: XX000

I look for the library:
find -name libperl.so

...and I see it in these locations:
./usr/lib/perl5/5.18.2/i586-linux-thread-multi/CORE/libperl.so
./usr/lib/perl5/5.18.2/x86_64-linux-thread-multi/CORE/libperl.so

So I conclude that it is already on my server distribution, but isn't in the location postgres is looking so I search and find this link:
https://www.postgresql.org/message-id/D960CB61B694CF459DCFB4B0128514C207B2C9DC%40exadv11.host.magwien.gv.at

...and I am opting do this (from the link above, but I have different paths): "- Add the directory that contains libperl.so to /etc/ld.so.conf and run "ldconfig" as root user. Then start the PostgreSQL server."

So I find the config file:
find -name ld.so.conf

And get this path:
./etc/ld.so.conf

...and edit the file:
vi ./etc/ld.so.conf

... and add this path:
./usr/lib/perl5/5.18.2/x86_64-linux-thread-multi/CORE/

... load the new config:
ldconfig

... restart pg:
systemctl restart postgresql-10.service

... run this query:
CREATE EXTENSION plperlu;

...and get the same error:
ERROR: could not load library "/var/lib/pgsql10/lib/postgresql/plperl.so": libperl.so: cannot open shared object file: No such file or directory
SQL state: XX000

...when I replace the previous path and add this path:
/usr/lib/perl5/5.18.2/x86_64-linux-thread-multi/CORE

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

... a little different error, but I don't know if I am closer or further away.
How do I get PostgreSQL pointed to the correct library so I can use perl?

I have:

* PostgreSQL 10.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-18), 64-bit
* pgAdmin 4 2.0
* SUSE Linux Enterprise 12 64-bit virtual server

PS - If you prefer Stackoverflow, I asked the exact question here, but haven't gotten any traction yet:
https://stackoverflow.com/questions/47578148/error-could-not-load-library-libperl-so-postgresql-trying-to-create-extension

Thanks!
Ben

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2017-11-30 22:35:59 Re: ERROR: could not load library libperl.so, PostgreSQL trying to CREATE EXTENSION plperlu
Previous Message Ted Toth 2017-11-30 20:27:58 Re: large numbers of inserts out of memory strategy