createlang plperl fails with 8.0 beta5

Started by Joachim Zobelover 21 years ago5 messagesgeneral
Jump to latest
#1Joachim Zobel
jzobel@heute-morgen.de

Hi.

If I try createlang plperl I get:

postgres@asus:~$ /usr/local/pgsql/bin/createlang plperl shop
createlang: language installation failed: ERROR: could not access file
"$libdir/plperl": No such file or directory

Checking my build dirs I find that no plperl.so has been build
(--with-perl was used in configure). Instead I find a libplperl.so in
the pgperl build directory.

Has plperl.so been renamed? Any hints on what is going wrong?

Thanks,
Joachim

--
"... ein Geschlecht erfinderischer Zwerge, die fuer alles gemietet werden
koennen." - Bertolt Brecht - Leben des Galilei

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Joachim Zobel (#1)
Re: createlang plperl fails with 8.0 beta5

Joachim Zobel <jzobel@heute-morgen.de> writes:

Checking my build dirs I find that no plperl.so has been build
(--with-perl was used in configure). Instead I find a libplperl.so in
the pgperl build directory.

That's how it's built, but it should be installed as plperl.so. Are you
sure you are looking in the right $libdir?

regards, tom lane

#3Joachim Zobel
jzobel@heute-morgen.de
In reply to: Tom Lane (#2)
Re: createlang plperl fails with 8.0 beta5

Am Mi, den 01.12.2004 schrieb Tom Lane um 21:22:

Joachim Zobel <jzobel@heute-morgen.de> writes:

Checking my build dirs I find that no plperl.so has been build
(--with-perl was used in configure). Instead I find a libplperl.so in
the pgperl build directory.

That's how it's built, but it should be installed as plperl.so. Are you
sure you are looking in the right $libdir?

I did not give any directory options during install, so

ls -l /usr/local/pgsql/lib/ | grep perl

should show it, right?

Thanks,
Joachim

--
"... ein Geschlecht erfinderischer Zwerge, die fuer alles gemietet werden
koennen." - Bertolt Brecht - Leben des Galilei

#4Tom Lane
tgl@sss.pgh.pa.us
In reply to: Joachim Zobel (#3)
Re: createlang plperl fails with 8.0 beta5

Joachim Zobel <jzobel@heute-morgen.de> writes:

Am Mi, den 01.12.2004 schrieb Tom Lane um 21:22:

That's how it's built, but it should be installed as plperl.so. Are you
sure you are looking in the right $libdir?

I did not give any directory options during install, so
ls -l /usr/local/pgsql/lib/ | grep perl
should show it, right?

Probably more like /usr/local/lib/postgresql ... did you look at the
directory structure? Or consult pg_config --pkglibdir ?

regards, tom lane

#5Joachim Zobel
jzobel@heute-morgen.de
In reply to: Tom Lane (#4)
Re: createlang plperl fails with 8.0 beta5

Am Mi, den 01.12.2004 schrieb Tom Lane um 22:00:

Probably more like /usr/local/lib/postgresql ... did you look at the
directory structure? Or consult pg_config --pkglibdir ?

jo@asus:~$ /usr/local/pgsql/bin/pg_config --pkglibdir
/usr/local/pgsql/lib

and there is

jo@asus:~$ ls -l /usr/local/pgsql/lib/ | grep pl
-rwxr-xr-x 1 root staff 146322 2004-12-01 09:27 plpgsql.so

I fixed this by copying libplperl.so.0.0 to
/usr/local/pgsql/lib/plperl.so. Probably there is some glitch in the
Makefile or in ./configure.

Thx,
Joachim

--
"... ein Geschlecht erfinderischer Zwerge, die fuer alles gemietet werden
koennen." - Bertolt Brecht - Leben des Galilei