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

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

From
"Dey, Sutapa"
Date:
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=3D/opt/pgsql/lib/:/opt/pgsql/vsm-lib:/usr/lib:/opt/p=
gsql/lib/hpux32

export libdir=3D/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=3D"cc -v", LDOPTS=3D"+nodefaultrpath")

d)     ./configure --prefix=3D/opt/iexpress/postgresql --with-perl --enable=
-integer-datetimes --with-openssl --libdir=3D/opt/iexpress/postgresql/lib/h=
pux32 --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/GNUmakefil=
e install



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

   $ /opt/iexpress/postgresql/bin/createlang --echo --dbname=3Dvsm --userna=
me=3Dpostgres plperl



   SELECT oid FROM pg_catalog.pg_language WHERE lanname =3D '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