Обсуждение: 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