Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M44523=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Za8Dl-0001IQ-VJ
 for pgsql-admin@arkaria.postgresql.org; Thu, 10 Sep 2015 20:13:26 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-admin-owner+M44523=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Za8Dl-0007YP-5A
 for pgsql-admin@arkaria.postgresql.org; Thu, 10 Sep 2015 20:13:25 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <ktm@aart.rice.edu>) id 1Za8Dk-0007YE-Pz
 for pgsql-admin@postgresql.org; Thu, 10 Sep 2015 20:13:24 +0000
Received: from proofpoint1.mail.rice.edu ([128.42.201.100] helo=pp1.rice.edu)
 by magus.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84)
 (envelope-from <ktm@aart.rice.edu>) id 1Za8Df-0001gX-Rd
 for pgsql-admin@postgresql.org; Thu, 10 Sep 2015 20:13:23 +0000
Received: from pps.filterd (pp1.rice.edu [127.0.0.1])
 by pp1.rice.edu (8.15.0.59/8.15.0.59) with SMTP id t8AK9Eqs020530;
 Thu, 10 Sep 2015 15:13:16 -0500
Received: from mh1.mail.rice.edu (mh1.mail.rice.edu [128.42.201.20])
 by pp1.rice.edu with ESMTP id 1wt32b9rn3-1;
 Thu, 10 Sep 2015 15:13:16 -0500
X-Virus-Scanned: by amavis-2.7.0 at mh1.mail.rice.edu, auth channel
X-SMTP-Auth: no
X-SMTP-Auth: no
Received: from aart.rice.edu (aart.rice.edu [168.7.56.48])
 by mh1.mail.rice.edu (Postfix) with ESMTP id 13DC84601ED;
 Thu, 10 Sep 2015 15:13:16 -0500 (CDT)
Received: by aart.rice.edu (Postfix, from userid 18612)
 id 08D121008CC; Thu, 10 Sep 2015 15:13:16 -0500 (CDT)
Date: Thu, 10 Sep 2015 15:13:15 -0500
From: "ktm@rice.edu" <ktm@rice.edu>
To: John Scalia <jayknowsunix@gmail.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Cannot get extensions to load
Message-ID: <20150910201315.GI18476@aart.rice.edu>
References: 
 <CABzCKRDCXGpwi0bzaPnzjRNBhqYcEdcAVX1YiF_Lu=Qzz_XGjg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CABzCKRDCXGpwi0bzaPnzjRNBhqYcEdcAVX1YiF_Lu=Qzz_XGjg@mail.gmail.com>
User-Agent: Mutt/1.5.20 (2009-12-10)
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0
 kscore.is_bulkscore=0
 kscore.compositescore=1 compositescore=0.9 suspectscore=0 malwarescore=0
 phishscore=0 bulkscore=0 kscore.is_spamscore=0 rbsscore=0.9 spamscore=0
 urlsuspectscore=0.9 adultscore=0 classifier=spam adjust=0 reason=mlx
 scancount=1 engine=8.0.1-1507310000 definitions=main-1509100275
X-Pg-Spam-Score: -4.2 (----)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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