From: Tom Lane <tgl@sss.pgh.pa.us>
To: Craig James <cjames@emolecules.com>
cc: pgsql-admin@postgresql.org
Subject: Re: 9.2 won't load C-language function
In-reply-to: 
 <CAFwQ8reTRHRgfhwQ-yQ+121JBwg67fEwQb677A_-j1CJQCztoA@mail.gmail.com>
References: 
 <CAFwQ8reTRHRgfhwQ-yQ+121JBwg67fEwQb677A_-j1CJQCztoA@mail.gmail.com>
Comments: In-reply-to Craig James <cjames@emolecules.com>
	message dated "Wed, 10 Oct 2012 11:22:17 -0700"
Date: Wed, 10 Oct 2012 17:11:07 -0400
Message-ID: <10507.1349903467@sss.pgh.pa.us>

Craig James <cjames@emolecules.com> writes:
> ERROR:  could not load library "/usr/local/pgsql/lib/libchmoogle.so":
> libopenbabel.so.4: cannot open shared object file: No such file or directory

> But libopenbabel.so.4 does exist:

> # ls -l /usr/local/pgsql/lib/libopenbabel.so.4
> -rwxr-xr-x 1 root root 18250709 2012-10-09 18:05
> /usr/local/pgsql/lib/libopenbabel.so.4*

It may exist, but is it in the dynamic linker's search path?

You didn't say what platform this is, but on Linux you normally have to
negotiate with ldconfig, or else set rpath in the referencing shlib,
if you want to use shlibs that are in nonstandard directories.

> What changed in how libraries are loaded between 8.4 and 9.2?

Nothing, AFAIR.  But you may have dropped an rpath spec when rebuilding
your library, or forgotten about a ldconfig adjustment you made on the
old machine.

			regards, tom lane