Re: [GENERAL] PG 10 and perl

Поиск
Список
Период
Сортировка
От Andy Colson
Тема Re: [GENERAL] PG 10 and perl
Дата
Msg-id 52ecfb23-80f3-332a-5adf-10d351149f17@squeakycode.net
обсуждение исходный текст
Ответ на Re: [GENERAL] PG 10 and perl  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On 09/29/2017 09:32 AM, Tom Lane wrote:
> Andy Colson <andy@squeakycode.net> writes:
>> I started playing with 10, and cannot get it to use the right version of perl.  I'll only use the system version:
>> root@firefly:/usr/local/pg10/lib/postgresql# ldd plperl.so
>>     libperl.so => /usr/lib64/perl5/CORE/libperl.so (0x00007fc9c67d4000)
> 
> Hm, I don't think we've changed anything about that in v10.
> 
>> But, here's the thing.  The config.log reports 5.26 version:
> 
> That's good, but what's probably missing is an "rpath" specification when
> linking plperl.so.  Did you build with --disable-rpath, perhaps?  That's
> the usual recommendation when building for Linux, but if you want to use
> any non-default libraries, you can't do it.
> 
> Go into src/pl/plperl, remove and remake plperl.so, and see whether the
> link command includes anything like
> 
>     -Wl,-rpath,'/usr/lib64/perl5/CORE',--enable-new-dtags
> 
> (That's what I see when building with a stock Linux Perl configuration and
> rpath enabled.)  If there's no such switch, or if it doesn't point to
> where the libperl.so that you want to use is, then there's your problem.
> 
>             regards, tom lane
> 

tldr: PG 10 compiles fine and works with perlbrew fine, I confused install paths.

I removed the plperl.so, and typed make:

gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security-fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fPIC -DLINUX_OOM_SCORE_ADJ=0 -fPIC
-shared-o plperl.so plperl.o SPI.o Util.o  -L../../../src/port -L../../../src/common -Wl,--as-needed
-Wl,-rpath,'/opt/perl5/perls/perl-5.26/lib/5.26.1/x86_64-linux-thread-multi/CORE',--enable-new-dtags
-fstack-protector-strong-L/usr/local/lib  -L/opt/perl5/perls/perl-5.26/lib/5.26.1/x86_64-linux-thread-multi/CORE -lperl
-lpthread-lnsl -ldl -lm -lcrypt -lutil -lc
 


And in the src dir:
root@firefly:/tmp/SBo/postgresql-10rc1# ldd ./src/pl/plperl/plperl.solibperl.so =>
/opt/perl5/perls/perl-5.26/lib/5.26.1/x86_64-linux-thread-multi/CORE/libperl.so(0x00007f33b9f87000)
 


I had 10beta1 installed to /usr/local/pg10.
The SlackBuild script I'm using installs to /usr/local/pg95 still.  So I was compiling and installing 10rc1 into pg95.

Sorry for the noise (and thanks Tom).

-Andy


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Victor Yegorov
Дата:
Сообщение: Re: [GENERAL] Converting inherited partitions into declarative ones
Следующее
От: Glen Huang
Дата:
Сообщение: [GENERAL] Best way to allow column to initially be null?