Re: 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.x86_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.klaver@aklaver.com