Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZUXph-0000od-Sq for pgsql-pkg-yum@arkaria.postgresql.org; Wed, 26 Aug 2015 10:21:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZUXpg-0002vC-St for pgsql-pkg-yum@arkaria.postgresql.org; Wed, 26 Aug 2015 10:21:28 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZUXpd-0002s6-Nf for pgsql-pkg-yum@postgresql.org; Wed, 26 Aug 2015 10:21:25 +0000 Received: from ns3.gunduz.org ([107.170.88.27] helo=ns1.gunduz.org) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZUXpW-0003x8-Os for pgsql-pkg-yum@postgresql.org; Wed, 26 Aug 2015 10:21:24 +0000 Received: from asus-laptop-03.gunduz.org (unknown [176.239.71.198]) (using TLSv1.2 with cipher AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by ns1.gunduz.org (Postfix) with ESMTPSA id 4543F4186A; Wed, 26 Aug 2015 10:21:19 +0000 (UTC) Message-ID: <1440584472.14665.7.camel@gunduz.org> Subject: Re: Control Files Missing from postgis2_92 Installation on CentOS 5 x86_64 From: Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= To: Jeff Misener , "pgsql-pkg-yum@postgresql.org" Date: Wed, 26 Aug 2015 13:21:12 +0300 In-Reply-To: <6C870E3DBC60D3478F24499BD1F8DABB062C6DC70D@SCOOBY.corp.eastlink.ca> References: <6C870E3DBC60D3478F24499BD1F8DABB062C6DC70D@SCOOBY.corp.eastlink.ca> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.16.5 (3.16.5-1.fc22) Mime-Version: 1.0 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -3.3 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-pkg-yum Precedence: bulk Sender: pgsql-pkg-yum-owner@postgresql.org Hi, The gdal version in RHEL 5 is insufficient for raster support, and raster support is required for creating the extension. I think the only solution is using a recent RHEL version. Regards, Devrim On Thu, 2015-07-30 at 18:55 -0300, Jeff Misener wrote: > Hello, > > I'm trying to enable the postgis extension on an installation of > postgis2_92 from pgdg-92-centos.repo, but it seems that > postgis.control is missing: > > [postgres@webapp01 ~]$ psql twist > psql (9.2.13) > Type "help" for help. > > twist=# CREATE EXTENSION postgis; > ERROR: could not open extension control file "/usr/pgsql > -9.2/share/extension/postgis.control": No such file or directory > > Here's a listing of the extension directory: > > [root@webapp01 ~]# ls -l /usr/pgsql-9.2/share/extension/ > total 12 > -rw-r--r-- 1 root root 332 Jun 11 09:13 plpgsql--1.0.sql > -rw-r--r-- 1 root root 179 Jun 11 09:13 plpgsql.control > -rw-r--r-- 1 root root 381 Jun 11 09:13 plpgsql--unpackaged--1.0.sql > > Here are the packages I have installed: > > [root@webapp01 ~]# yum list postg* > [...] > Installed Packages > postgis2_92.x86_64 > 2.0.6-2.rhel5 > installed > postgis2_92-client.x86_64 > 2.0.6-2.rhel5 > installed > postgis2_92-debuginfo.x86_64 > 2.0.6-2.rhel5 > installed > postgis2_92-devel.x86_64 > 2.0.6-2.rhel5 > installed > postgis2_92-docs.x86_64 > 2.0.6-2.rhel5 > installed > postgis2_92-utils.x86_64 > 2.0.6-2.rhel5 > installed > postgresql92.x86_64 > 9.2.13-1PGDG.rhel5 > installed > postgresql92-devel.x86_64 > 9.2.13-1PGDG.rhel5 > installed > postgresql92-libs.x86_64 > 9.2.13-1PGDG.rhel5 > installed > postgresql92-server.x86_64 > 9.2.13-1PGDG.rhel5 > installed > postgresqlclient81.x86_64 > 8.1.17-1.el5.centos > installed > > I have postgresqlclient81.x86_64 installed to support some existing > applications. Could that be causing a problem? Any help you could > provide would be much appreciated. > > Thanks, > Jeff -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR -- Sent via pgsql-pkg-yum mailing list (pgsql-pkg-yum@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-pkg-yum