Re: Cannot get extensions to load

Thanks Craig, that pretty much confirms what my suspicions were anyway.

On Fri, Sep 11, 2015 at 8:03 AM, Craig James <cjames(at)emolecules(dot)com> wrote:

> On Thu, Sep 10, 2015 at 1:18 PM, John Scalia <jayknowsunix(at)gmail(dot)com>
> wrote:
>
>> Thanks, Ken,
>>
>> These extensions built without any issues on my sandbox server and I've
>> been watching the powa web page for some time. I thought I could copy the
>> extensions over to another system and have the powa database on that system
>> have those extensions created. Some further research on my part has
>> revealed that the files needed in /usr/pgsql-9.4/lib for these extensions
>> didn't get copied over (someone else wrote the script, sigh...) So, I think
>> that may be the problem. What I now don't understand is how did the powa
>> extension get created as that one also has a lib.so which isn't present,
>> yet the create extension succeeded for that one.
>>
>
> If the extension references libA.so, and libA.so references libB.so, then
> you could probably create the extension without libB.so being present on
> the system. My experience is that it doesn't invoke the full linking
> process until you actually use the extension. That's when missing secondary
> libraries are discovered.
>
> Craig
>
>
>>
>> On Thu, Sep 10, 2015 at 3:13 PM, ktm(at)rice(dot)edu <ktm(at)rice(dot)edu> wrote:
>>
>>> On Thu, Sep 10, 2015 at 02:53:40PM -0500, John Scalia wrote:
>>> > Hi all,
>>> >
>>> > New problem I've not seen before... I'm working with the POWA query
>>> > monitoring package and have that working on my sandbox server. I want
>>> to
>>> > use this on several development systems here, but I cannot do a normal
>>> > install of the extensions needed as loading the postgresql94-devel rpm
>>> > wants to upgrade our current 9.4 installations to a newer version. So,
>>> I've
>>> > copied the extensions over to another system and have tried to do
>>> "create
>>> > extension <xxxx>;" on that system, but only the powa extension is
>>> loading.
>>> > Neither the pg_qualstats nor the pg_stats_kcache will create. What I
>>> find a
>>> > little weird is that psql keeps saying that it can't find
>>> > "$libdir/pg_xxxxxx" yet I see the .sql files and the control file in
>>> the
>>> > /usr/pgsql-9.4/share/extension directory. BTW, these are all CentO/S
>>> > servers, and the Db is 9.4.2. Could it be that since these were
>>> created on
>>> > my sandbox which is running 9.4.4 that the extensions just can't load
>>> or is
>>> > something else I don't see going on?
>>> > --
>>> > Jay
>>>
>>> Hi Jay,
>>>
>>> I do not know if this is your problem, but I could not build/install
>>> extensions because I was missing some static libraries. In my case,
>>> I needed to install 'yum install readline-static' before it would
>>> successfully build and install. Try a manual build and see what libraries
>>> it cannot find and add the static versions. Then the install should
>>> complete.
>>>
>>> Regards,
>>> Ken
>>>
>>
>>
>
>
> --
> ---------------------------------
> Craig A. James
> Chief Technology Officer
> eMolecules, Inc.
> ---------------------------------
>