Re: Cannot get extensions to load

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.
---------------------------------