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