The following bug has been logged on the website:
Bug reference: 8343
Logged by: Charles Sheridan
Email address: cesheri@swbell.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.