Createlang Language Installation Failed Error Could Not Load Library
Contents |
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project lists
Error: Could Not Access File "$libdir/plperl": No Such File Or Directory
Inactive lists IRC Local User Groups Featured Users International Sites plperl dll the specified module could not be found Propaganda Resources Weekly News Re: could not load library plperl.so From: CSN
Postgresql Plperl Install
Subject: Re: could not load library plperl.so Date: 2005-05-02 02:08:39 Message-ID: 20050502020839.72596.qmail@web52907.mail.yahoo.com (view raw or whole thread) Thread: 2005-05-02 02:08:39 from CSN
create language plperlu. It indicates that there is a missing library libperl.so. Check out the steps performed to overcome this issue and successfully creating the plperlu language in PostgreSQL. Method 1 (Finding the libperl.so and making softlink to that location) postgres=# create LANGUAGE plperlu; ERROR: could not load library "/opt/PostgreSQL/9.0/lib/postgresql/plperl.so": libperl.so: cannot open shared object file: No such file or directory postgres=# \q Now, search for the file libperl.so on your https://www.postgresql.org/message-id/20050502020839.72596.qmail@web52907.mail.yahoo.com box and add that location to your LD_LIBRARY PATH. Dont forget switching user to postgres. [root@localhost /]# find -name libperl.so ./usr/lib/perl5/5.10.0/i386-linux-thread-multi/CORE/libperl.so ./usr/lib/perl5/CORE/libperl.so ./usr/lib/perl5/5.10.0/i386-linux-thread-multi/CORE [root@localhost /]# su - postgres Set the LD_LIBRARY_PATH -bash-4.1$ export LD_LIBRARY_PATH=/usr/lib/perl5/5.10.0/i386-linux-thread-multi/CORE:$LD_LIBRARY_PATH Restart the cluster to effect the changes. -bash-4.1$ pg_ctl restart waiting for server to shut down....... http://raghavt.blogspot.com/2011/04/error-could-not-load-library.html done server stopped server starting You are now ready to create the language. -bash-4.1$ psql psql (9.0.1) Type "help" for help. postgres=# create LANGUAGE plperlu; CREATE LANGUAGE Method 2 (By installing the latest ActivePerl) Step 1: After installing ActivePerl, set the LD_LIBRARY_PATH. postgres@localhost:/opt/ActivePerl-5.12/lib/CORE> export LD_LIBRARY_PATH=/opt/ActivePerl-5.12/lib/CORE:/opt/PostgreSQL/9.0/lib/postgresql Step 2: postgres@localhost:/opt/PostgreSQL/9.0/lib/postgresql> ldd plperl.so linux-vdso.so.1 => (0x00007fff8cf79000) libperl.so => /opt/ActivePerl-5.12/lib/CORE/libperl.so (0x00007fbd3d654000) libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fbd3d40a000) libdl.so.2 => /lib64/libdl.so.2 (0x00007fbd3d206000) libm.so.6 => /lib64/libm.so.6 (0x00007fbd3cfb0000) libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fbd3cd74000) libutil.so.1 => /lib64/libutil.so.1 (0x00007fbd3cb71000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fbd3c954000) libc.so.6 => /lib64/libc.so.6 (0x00007fbd3c5f5000) /lib64/ld-linux-x86-64.so.2 (0x00007fbd3dad8000) Step 3: postgres@localhost:/opt/PostgreSQL/9.0/lib/postgresql> pg_ctl restart postgres@localhost:/opt/PostgreSQL/9.0/lib/postgresql> psql psql (9.0.2) Type "help" for help. postgres=# create language plperlu; CREATE LANGUAGE Post your comments. --Raghav By Raghavendra 1 comment : Valeriano Cossu said... on Debian install libperl-dev and try to createlang again August 27, 2014 at 3:04 AM Post a Comment Newer Post Older Post Home About Me Raghavendra MCA, Oracle Certified Profession
Message 1 Aug 2013 08:40:41 Subject: Problem with PL/Perl RobertS New member Joined: 5 Jul 2013 03:56:31 Messages: 4 Offline Hello everyone. http://forums.enterprisedb.com/posts/list/3736.page I was trying to install and test PL/Perl and maybe other procedural https://discuss.pivotal.io/hc/en-us/articles/206789577-Fail-to-run-createlang-during-PLR-installation language. But I am still struggling with installation. ./createlang -U enterprisedb -d fromoracle plperl createlang: language installation failed: ERROR: could not load library "/opt/PostgresPlus/9.2AS/lib/plperl.so": /opt/PostgresPlus/9.2AS/lib/plperl.so: undefined symbol: Perl_sv_2bool_flags ldd /opt/PostgresPlus/9.2AS/lib/plperl.so linux-vdso.so.1 => (0x00007fffaf14e000) libperl.so => /opt/PostgresPlus/9.2AS/lib/libperl.so (0x00007fb1e73bb000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fb1e7192000) libc.so.6 => /lib64/libc.so.6 (0x00007fb1e6e00000) libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fb1e6be6000) libnsl.so.1 => could not /lib64/libnsl.so.1 (0x00007fb1e69cc000) libdl.so.2 => /lib64/libdl.so.2 (0x00007fb1e67c8000) libm.so.6 => /lib64/libm.so.6 (0x00007fb1e6544000) libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fb1e630c000) libutil.so.1 => /lib64/libutil.so.1 (0x00007fb1e6109000) /lib64/ld-linux-x86-64.so.2 (0x0000003b04400000) libfreebl3.so => /lib64/libfreebl3.so (0x00007fb1e5ea7000) Could you please help me to solve this ? RedHat 6.3 PG 9.2 This message was edited 2 times. Last update was at 7 Aug 2013 04:01:46 9 Aug 2013 11:16:19 Subject: Re:Problem with PL/Perl Irfin_A New member createlang language installation Joined: 23 Oct 2007 23:59:56 Messages: 2 Offline Hi there, First off, pardon me for my limited english. For about 2 days ago I was having same issue when trying to install PL/Perl on my PostgreSQL 9.1 on CentOS 6. By the time I'm writing this post, I'm still trying to install PL/Perl for the purpose of running replication using Bucardo. So when I execute: /opt/PostgreSQL/9.1/bin/createlang plperl template1 -U postgres I got error message: undefined symbol: Perl_sv_2bool_flags After looking for hints everywhere, I conclude that the Perl installed in my CentOS 6 is not compatible with PostgreSQL 9.1 PL/Perl needs. I decided to reinstall Perl from the source. I downloaded Perl source version 5.18.0 and compile it (doing ./Configure, make, make test, and make install). And after doing some adjustment to file /etc/ld.so.conf so that it points to directory where file libperl.so (which was generated from that compile process) located and then issuing command `ldconfig` as root, then I start to do it again: /opt/PostgreSQL/9.1/bin/createlang plperl template1 -U postgres Then I got another error message, which says it cannot find symbol Perl_thr_key And (again) after some searc
01, 2015 14:18 Environment HAWQ 1.3.x Symptom Follow the steps mentioned in installation guide, but got problem with "createlang plr", as shown below. [gpadmin@admin ~]$ createlang plr -d dw1createlang: language installation failed: ERROR: could not load library "/usr/local/hawq-1.3.0.1/lib/postgresql/plr.so": libR.so: cannot open shared object file: No such file or directory Cause With installation of PLR package $GPHOME/greenplum_path.sh file will be changed to add PLR related info for environment settings. For example R library path "/usr/local/hawq/./ext/R-2.13.0/lib64/R/lib" will be added to environment variable LD_LIBRARY_PATH. However to make the change effect, $GPHOME/greenplum_path.sh needs to be sourced again followed by HAWQ system restart. Fix As gpadmin user on HAWQ master host 1) Run "source $GPHOME/greenplum_path.sh" 2) Run "gpstop -a -r" to restart HAWQ 3) Run "createlang plr -d