Thread: PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64 bit)
Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8
and get from https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x86_64.rpm.html - 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 |
Hanan Brener <hbrener@allot.com> writes: > Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8 > and get from https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x86_64.rpm.html - 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 Seems like you've got a broken build of plruby there. FunctionCall3 has been a macro, not a real function, for quite a long time. AFAICS this error would only be possible if plruby had been compiled against postgres header files from 9.0 or before, which would be a packaging mistake. Suggest complaining to whoever the package builder is. regards, tom lane
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
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.klaver@aklaver.com] Sent: Thursday, June 30, 2016 7:47 PM To: Hanan Brener <hbrener@allot.com>; pgsql-general@postgresql.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.klaver@aklaver.com
On 06/30/2016 10:08 AM, Hanan Brener wrote: > The Postgresql server 9.5 installed from (www.enterprisedb.com/) I don't know how you would do that. I saw(sort of) your post on the EDB forum: http://forums.enterprisedb.com/jforum.page?module=search&action=search&forum=3&match_type=all&search_keywords=ruby Clicking on the link yielded: "The topic you are trying to see does not exist." So you might want to try again there. > > Hanan Brener > Database and Data Collection Team Leader > Allot Communications > > > > > > > -----Original Message----- > From: Adrian Klaver [mailto:adrian.klaver@aklaver.com] > Sent: Thursday, June 30, 2016 7:47 PM > To: Hanan Brener <hbrener@allot.com>; pgsql-general@postgresql.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.klaver@aklaver.com > -- Adrian Klaver adrian.klaver@aklaver.com