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