Re: Problem with pl/perl in postgresql

From: "Iain" <iain(at)mst(dot)co(dot)jp>
To: "pgsqlnovice" <pgsql-novice(at)postgresql(dot)org>
Cc: <rboone(at)mail(dot)wtamu(dot)edu>
Subject: Re: Problem with pl/perl in postgresql
Date: 2005-01-19 03:28:01
Message-ID: 000301c4fdd6$e4ae66c0$7201a8c0@mst1x5r347kymb
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I just had a similar problem, but your solution (as posted anyway) didn't
work for me.

My system is RHEL3 and the libperl.so file is in the path as you specified.
Postgres is 7.4.6 from the source tar file.

In the end, I did (as root)

# cp /usr/lib/perl5/5.8.0//i386-linux-thread-multi/CORE/libperl.so /usr/lib

# ldconfig

and it was fine after that, I didn't need to rebuild postgres.

From reading the manual, I thought that using :

ldconfig /usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
or maybe
ldconfig -l /usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so

should have worked, but calling ldconfig -p | grep perl showed that the lib
wasn't included.

Regards
Iain

>>>>>Hello,

I think I got it installed. I did have have libperl.so but for some
reason it wasn't being picked up by ld.so.conf.

So I:
ldconfig /usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so

Then I rebuilt the postgresql srpm. And I was able to do:
createlang plperl test

And it worked.

Thanks to everyone that replied.

Robert Boone

<<<<<

Browse pgsql-novice by date

  From Date Subject
Next Message Pradeepkumar, Pyatalo (IE10) 2005-01-19 05:29:32 dropdb command not working.
Previous Message Keith Worthington 2005-01-18 18:54:00 Re: How the get variables out of a plggsql RECORD by column number