Обсуждение: BUG #8343: plperl/plperlu Install Fails

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.

This is fixed in the latest version PostgreSQL 9.3 beta2.


On Sun, Jul 28, 2013 at 11:07 AM, <cesheri@swbell.net> wrote:

> 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.
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>



--
Sandeep Thakkar

> This is fixed in the latest version PostgreSQL 9.3 beta2.

I have upgraded to PostgreSQL 9.3.1 on x86_64-apple-darwin, compiled by
i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build
5658) (LLVM build 2336.9.00), 64-bit

My laptop is the following:
Model Identifier: MacBookPro10,1 Processor Name: Intel Core i7
System Version: OS X 10.9 (13A603)
Kernel Version: Darwin 13.0.0

When I execute either SQL statement:
create language plperlu;
create extension plperlu;

It returned an error that it could not load the library.

I then loaded PERL 5.16 but it still generates the following error messages:

ERROR:  could not load library
"/Library/PostgreSQL/9.3/lib/postgresql/plperl.so":
dlopen(/Library/PostgreSQL/9.3/lib/postgresql/plperl.so, 10): Library not
loaded: /usr/local/ActivePerl-5.14/lib/CORE/libperl.dylib
  Referenced from: /Library/PostgreSQL/9.3/lib/postgresql/plperl.so
  Reason: no suitable image found.  Did find:
/usr/local/lib/libperl.dylib: stat() failed with errno=13

********** Error **********

ERROR: could not load library
"/Library/PostgreSQL/9.3/lib/postgresql/plperl.so":
dlopen(/Library/PostgreSQL/9.3/lib/postgresql/plperl.so, 10): Library not
loaded: /usr/local/ActivePerl-5.14/lib/CORE/libperl.dylib
  Referenced from: /Library/PostgreSQL/9.3/lib/postgresql/plperl.so
  Reason: no suitable image found.  Did find:
/usr/local/lib/libperl.dylib: stat() failed with errno=13
SQL state: 58P01

The library is in the directory:

/Library/PostgreSQL/9.3/lib/postgresql $ ls plperl* plperl.so

What am I missing?

Thank you,

Pat