Quick Links

Re: SHARED LIBRARY IS NOT CREATED:Postgres could not create support for plperl

From:	John R Pierce <pierce(at)hogranch(dot)com>
To:	PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject:	Re: SHARED LIBRARY IS NOT CREATED:Postgres could not create support for plperl
Date:	2008-11-12 07:58:22
Message-ID:	491A8C9E.3060807@hogranch.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Dey, Sutapa wrote:
<blockquote
cite="mid:D264563FEECCAD4FBDE4B92D3863256A4B4909EBD9(at)GVW0440EXB(dot)americas(dot)hpqcorp(dot)net"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style>

</style>

<div class="Section1">
Hi
All,<o:p></o:p>
<o:p> </o:p>
I
am trying to build/enable plperl support for postgres.<o:p></o:p>
<o:p> </o:p>
1.
The system info is :<o:p></o:p>
#
uname -a<o:p></o:p>
HP-UX
unknown B.11.23 U 9000/800 1178464650 unlimited-user license<o:p></o:p>
<o:p> </o:p>
2.
The steps I followed:<o:p></o:p>
a)     
In
postgres user’s .profile file I had set :<o:p></o:p>
export
LD_LIBRARY_PATH=/opt/pgsql/lib/:/opt/pgsql/vsm-lib:/usr/lib:/opt/pgsql/lib/hpux32
export
libdir=/opt/pgsql/lib<o:p></o:p>
b)     
I
linked the libperl.sl from the perl library
“/usr/local/perl5/lib/5.8.3/PA-RISC2.0/CORE/libperl.sl” to:<o:p></o:p>
/opt/iexpress/postgresql/lib/libperl.sl<o:p></o:p>
/opt/iexpress/postgresql/lib/hpux32/libperl.sl<o:p></o:p>
<o:p> </o:p>
c)     
In
the postgres “src” directory,  I set the environment variables
(export CC=”cc –v”, LDOPTS="+nodefaultrpath")<o:p></o:p>
d)    
./configure
--prefix=/opt/iexpress/postgresql --with-perl
--enable-integer-datetimes
--with-openssl --libdir=/opt/iexpress/postgresql/lib/hpux32
--without-readline
--without-zlib --without-docdir<o:p></o:p>
e)     
/usr/local/bin/gmake
-f /opt/pgsql/src/postgresql-8.2.4/GNUmakefile all<o:p></o:p>
f)      
/usr/local/bin/gmake
-f /opt/pgsql/src/postgresql-8.2.4/GNUmakefile install<o:p></o:p>
<o:p> </o:p>
3.
After these steps when I try to create plperl language with postgres<o:p></o:p>
  
$ /opt/iexpress/postgresql/bin/createlang --echo --dbname=vsm
--username=postgres plperl<o:p></o:p>
<o:p> </o:p>
  
SELECT oid FROM pg_catalog.pg_language WHERE lanname = 'plperl';<o:p></o:p>
 
CREATE LANGUAGE "plperl";<o:p></o:p>
  
createlang: language installation failed: ERROR:  could not access file
"$libdir/plperl": No such file or directory<o:p></o:p>
<o:p> </o:p>
</div>
</blockquote>
 
first, let me say, I don't know squat about HPUX, just Unix in
general... 
 
assuming the postgres server is running as a daemon launched by some
sort of system service manager, chances are VERY good its not running
the .profile and isn't seeing that LD_LIBRARY_PATH.  you could add
this same thing to the launcher script that loads the postmaster
daemon.... 
 
however, at least in most newer unix systems, using LD_LIBRARY_PATH is
deprecated, you want to link the programs so they KNOW where they are
expecting to find their libaries and aren't dependent on additional
custom settings of environment variables at runtime...  often this is
done with the --rpath option to the linker...  perhaps step E could be
prefixed with... 
 
LDFLAGS = --rpath /opt/iexpress/postgresql/lib/
--rpath /opt/pgsql/lib/hpux32
--rpath /opt/pgsql/vsm-lib
\ 
    /usr/local/bin/gmake
-f /opt/pgsql/src/postgresql-8.2.4/GNUmakefile all 
 
 
 
</body>
</html>

Attachment	Content-Type	Size
unknown_filename	text/html	12.5 KB

In response to

SHARED LIBRARY IS NOT CREATED:Postgres could not create support for plperl at 2008-11-12 07:31:17 from Dey, Sutapa

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	Zou Yong	2008-11-12 08:34:34	BUG #4522: autovacuum working send SIGUSR1 to the wrong pid
Previous Message	Dey, Sutapa	2008-11-12 07:31:17	SHARED LIBRARY IS NOT CREATED:Postgres could not create support for plperl