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

From: "Dey, Sutapa" <sutapa(dot)dey(at)hp(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: SHARED LIBRARY IS NOT CREATED:Postgres could not create support for plperl
Date: 2008-11-11 12:14:34
Message-ID: D264563FEECCAD4FBDE4B92D3863256A4B4909E799@GVW0440EXB.americas.hpqcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi All,

I am trying to build/enable plperl support for postgres.

1. The system info is :

# uname -a

HP-UX unknown B.11.23 U 9000/800 1178464650 unlimited-user license

2. The steps I followed:

a) In postgres user's .profile file I had set :

export LD_LIBRARY_PATH=/opt/pgsql/lib/:/opt/pgsql/vsm-lib:/usr/lib:/opt/pgsql/lib/hpux32

export libdir=/opt/pgsql/lib

b) I linked the libperl.sl from the perl library "/usr/local/perl5/lib/5.8.3/PA-RISC2.0/CORE/libperl.sl" to:

/opt/iexpress/postgresql/lib/libperl.sl

/opt/iexpress/postgresql/lib/hpux32/libperl.sl

c) In the postgres "src" directory, I set the environment variables (export CC="cc -v", LDOPTS="+nodefaultrpath")

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

e) /usr/local/bin/gmake -f /opt/pgsql/src/postgresql-8.2.4/GNUmakefile all

f) /usr/local/bin/gmake -f /opt/pgsql/src/postgresql-8.2.4/GNUmakefile install

3. After these steps when I try to create plperl language with postgres

$ /opt/iexpress/postgresql/bin/createlang --echo --dbname=vsm --username=postgres plperl

SELECT oid FROM pg_catalog.pg_language WHERE lanname = 'plperl';

CREATE LANGUAGE "plperl";

createlang: language installation failed: ERROR: could not access file "$libdir/plperl": No such file or directory

My problem is it is not creating the shared library "plperl.sl"

Please help. May be I am missing something in the configure options.

Regards,

Sutapa

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-11-11 13:16:48 Re: BUG #4520: Cases where a forign key constraint is not inforced and when it is incorrectly inforced.
Previous Message Adam Terrey 2008-11-11 03:49:42 BUG #4520: Cases where a forign key constraint is not inforced and when it is incorrectly inforced.