BUG #8343: plperl/plperlu Install Fails

From: cesheri(at)swbell(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8343: plperl/plperlu Install Fails
Date: 2013-07-28 05:37:02
Message-ID: E1V3JfC-00075D-Jq@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8343
Logged by: Charles Sheridan
Email address: cesheri(at)swbell(dot)net
PostgreSQL version: 9.2.4
Operating system: Mac OS 10.8.4
Description:

In a psql 9.1.5
> create extension plperlu;
or
> create extension plperl;
=> "The connection to the server was lost. Attempting
reset: Failed."

In pgAdmin 1.16.1:
> GUI attempt to create the same extensions gets a fail window "An Error
has occured:" [ no more info ]

I can install other extensions successfully -- e.g. hstore.
The account has superuser privs.
There no other issues in running commands through pgsl and pgAdmin.

ActivePerl versions installed:
/usr/local/ActivePerl-5.14/bin/perl AND
/usr/local/ActivePerl-5.16/bin/perl

Both ActivePerl instances compiled w/ MULTIPLICITY. Also:
-r-xr-xr-x 1 root admin 3475248 Mar 13 14:49
/usr/local/ActivePerl-5.14/lib/CORE/libperl.dylib

No other apparent issues w/ the perl installations.

Activeperl 5.14 was already installed when Postgres 9.2.4 was originally
installed. Then, Activeperl 5.16 was installed and 5.14 was removed. My
first attempt to create extensions for perl had failed with this error:
> create extension plperlu;
ERROR: could not load library
"/Library/PostgreSQL/9.2/lib/postgresql/plperl.so":
dlopen(/Library/PostgreSQL/9.2/lib/postgresql/plperl.so, 10): Library not
loaded: /usr/local/Acti
vePerl-5.14/lib/CORE/libperl.dylib
Referenced from: /Library/PostgreSQL/9.2/lib/postgresql/plperl.so
Reason: image not found

I then reinstalled Activeperl 5.14 from web download, and got the errors
noted at the begin of this report.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message lucere 2013-07-28 11:37:49 BUG #8344: Python PL broken installation
Previous Message Pavel Stehule 2013-07-27 20:59:48 Re: BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL