The following bug has been logged on the website:
Bug reference: 10622
Logged by: Ron
Email address: ron@rajyaseva.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.
From:
jacek.zalewski@asseco.pl Date: Subject:
BUG #10611: pg_restore incorrectly restores DB dump (plain and tar
format) containing LARGE OBJECTS witdh commen