Re: PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

The Postgresql server 9.5 installed from (www.enterprisedb.com/)

Hanan Brener
Database and Data Collection Team Leader
Allot Communications

-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Sent: Thursday, June 30, 2016 7:47 PM
To: Hanan Brener <hbrener(at)allot(dot)com>; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)

On 06/30/2016 09:24 AM, Hanan Brener wrote:
> Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8

How did you install the Postgres server?

>
> and get from
> *https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x
> 86_64.rpm.html*

I would say where you install plruby from depends on where you installed Postgres from.

FYI the Postgres community has repos:

https://www.postgresql.org/download/linux/redhat/

> - *_plruby_* libraries(postgresql-plruby-0.5.3-4.el6.x86_64).
>
> Additional installed postgresql95-libs
> (postgresql95-libs-9.5.2-1PGDG.rhel6.x86_64)
>
> Trying add plruby to PostgreSQL -
>
> create function plruby_call_handler() returns language_handler
>
> as '/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so'
>
> language 'c';
>
> The follows error appears - could not load library
> "/usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so":
> /usr/lib64/ruby/site_ruby/1.8/x86_64-linux/plruby.so: undefined symbol:
> FunctionCall3
>
> Add libraries path to LD_LIBRARY+PATH environment variable, recreating
> ld .so.cache doesn't change result - the same error appears.
>
>
>
> What could be a problem!?
>
> Thanks in advance for any replies or tips how it could be done...
>
> *Hanan Brener*
>
> *Database and Data Collection Team Leader*
>
> Allot Communications
>
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com