Skip site navigation (1) Skip section navigation (2)

Re: 8.3 to 8.4 - Can't load dynamic shared library

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: 8.3 to 8.4 - Can't load dynamic shared library
Date: 2010-07-15 18:58:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Thu, 2010-07-15 at 11:49 -0700, Craig James wrote:
> I'm migrating from Postgres 8.3.10 to 8.4.4, and also from Fedora 9 to Ubuntu 10.04.
> On 8.3.10, I have a C extension that worked on 8.3, but now refuses to load on 8.4:
> CREATE OR REPLACE FUNCTION chmoogle_session_id() RETURNS integer
> AS '/usr/local/pgsql/lib/', 'chmoogle_session_id'
> ERROR:  could not load library "/usr/local/pgsql/lib/": /usr/local/pgsql/lib/ undefined symbol: _ZN9OpenBabel4etabE
> So it finds the first shared library,  But the symbol _ZN9OpenBabel4etabE is from a second library, the OpenBabel (chemistry) shared library, which is also located in
>    /usr/local/pgsql/lib/
> On the Postgres 8.3 system, I simply put into the /usr/local/pgsql/lib directory, and everything worked well.  On 8.4, I can't seem to get it to load  Other programs that use this library have no trouble finding it.
> What (if anything) has changed from 8.3 to 8.4 regarding how it finds and links dynamic libraries?  What else should I look for?  I'm stumped on this one.

Studid question, but did you recompile the library against 8.4 first?

> Thanks,
> Craig

-- Major Contributor
Command Prompt, Inc: - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering

In response to

pgsql-admin by date

Next:From: dx k9Date: 2010-07-15 19:17:25
Subject: tablespaces
Previous:From: Craig JamesDate: 2010-07-15 18:49:32
Subject: 8.3 to 8.4 - Can't load dynamic shared library

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group