BUG #10622: PLPerl extenstion install failure - why is it asking ActivePerl?

From: ron(at)rajyaseva(dot)in
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #10622: PLPerl extenstion install failure - why is it asking ActivePerl?
Date: 2014-06-11 18:32:51
Message-ID: 20140611183251.2585.98460@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: 10622
Logged by: Ron
Email address: ron(at)rajyaseva(dot)in
PostgreSQL version: 9.2.3
Operating system: Mac OS X 10.9.2
Description:

Hi
Im facing an issue in installing plperl , identical to what was reported in
Bug 8343 earlier.
http://www.postgresql.org/message-id/CANFyU96u8=YE4TSD5YqR8F_SHPi7Zqh+X5emuPM9uTQZEuc3xQ@mail.gmail.com

As postgres user i tried to install plperl via $createlang plperl <dbname>
but it throws the following error

createlang: language installation failed: 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/ActivePerl-5.14/lib/CORE/libperl.dylib
Referenced from: /Library/PostgreSQL/9.2/lib/postgresql/plperl.so
Reason: image not found

Question -> I am not able to understand why the configuration is looking at
/usr/local/ActivePerl..as there is no such path in my system where perl is
installed. I have installed perl from source.

Also libperl.so is present in
/Library/PostgreSQL/9.2/lib/postgresql/plperl.so.

Is the only solution to download the latest version of PostgresQL ? I have
another deployment of Postgres (9.2.8) on a hoste environment and i am able
to install plperl on the machine.

so please give me some idea why i am facing this issue and how to resolve it
without a fresh install.

thank you.

Regards
Ron.

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2014-06-12 03:14:54 Re: Re: Hot standby 9.2.6 -> 9.2.6 PANIC: WAL contains references to invalid pages
Previous Message Magnus Hagander 2014-06-11 16:11:07 Re: Unable to revoke insert privileges on a table