pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCannot get extensions to load
5+ messages / 3 participants
[nested] [flat]
* Cannot get extensions to load
@ 2015-09-10 19:53 John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: John Scalia @ 2015-09-10 19:53 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Cannot get extensions to load
@ 2015-09-10 20:13 ktm@rice.edu <ktm@rice.edu>
parent: John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: ktm@rice.edu @ 2015-09-10 20:13 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: pgsql-admin
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Cannot get extensions to load
@ 2015-09-10 20:18 John Scalia <jayknowsunix@gmail.com>
parent: ktm@rice.edu <ktm@rice.edu>
0 siblings, 1 reply; 5+ messages in thread
From: John Scalia @ 2015-09-10 20:18 UTC (permalink / raw)
To: ktm@rice.edu <ktm@rice.edu>; +Cc: pgsql-admin
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.
On Thu, Sep 10, 2015 at 3:13 PM, ktm@rice.edu <ktm@rice.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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Cannot get extensions to load
@ 2015-09-11 13:03 Craig James <cjames@emolecules.com>
parent: John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Craig James @ 2015-09-11 13:03 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; +Cc: ktm@rice.edu <ktm@rice.edu>; pgsql-admin
On Thu, Sep 10, 2015 at 1:18 PM, John Scalia <jayknowsunix@gmail.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@rice.edu <ktm@rice.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.
---------------------------------
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Cannot get extensions to load
@ 2015-09-11 13:21 John Scalia <jayknowsunix@gmail.com>
parent: Craig James <cjames@emolecules.com>
0 siblings, 0 replies; 5+ messages in thread
From: John Scalia @ 2015-09-11 13:21 UTC (permalink / raw)
To: Craig James <cjames@emolecules.com>; +Cc: ktm@rice.edu <ktm@rice.edu>; pgsql-admin
Thanks Craig, that pretty much confirms what my suspicions were anyway.
On Fri, Sep 11, 2015 at 8:03 AM, Craig James <cjames@emolecules.com> wrote:
> On Thu, Sep 10, 2015 at 1:18 PM, John Scalia <jayknowsunix@gmail.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@rice.edu <ktm@rice.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.
> ---------------------------------
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2015-09-11 13:21 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-09-10 19:53 Cannot get extensions to load John Scalia <jayknowsunix@gmail.com>
2015-09-10 20:13 ` ktm@rice.edu <ktm@rice.edu>
2015-09-10 20:18 ` John Scalia <jayknowsunix@gmail.com>
2015-09-11 13:03 ` Craig James <cjames@emolecules.com>
2015-09-11 13:21 ` John Scalia <jayknowsunix@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox