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

2017-12-03 Thread Peter J. Holzer
On 2017-11-30 15:49:28 -0800, Alan Hodgson wrote: > On Thu, 2017-11-30 at 22:59 +, Ben Nachtrieb wrote: > Thank you! Solution: build them from source on the server? > > Well, it would be more maintainable to find a source for packages built for > your particular OS. https://www.postgresq

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

2017-11-30 Thread Alan Hodgson
On Thu, 2017-11-30 at 22:59 +, Ben Nachtrieb wrote: > Alan, > >   > > Thank you!  Solution: build them from source on the server? Well, it would be more maintainable to find a source for packages built for your particular OS. Or run a supported OS; that one looks pretty old. Or I guess you ca

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

2017-11-30 Thread Ben Nachtrieb
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 Subject: Re: ERROR: could not load library libperl.so, PostgreSQL trying to CREATE EXTENSION plperlu On Thu

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

2017-11-30 Thread Alan Hodgson
On Thu, 2017-11-30 at 22:20 +, 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

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

2017-11-30 Thread Ben Nachtrieb
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