Postgis 2.1.7 upgrade fails - Mailing list pgsql-pkg-yum

From Jeroen van Vianen
Subject Postgis 2.1.7 upgrade fails
Date
Msg-id 06D55C75-6003-4CD6-A3AA-E5AC388DDFF6@vanvianen.nl
Whole thread Raw
Responses Re: Postgis 2.1.7 upgrade fails
List pgsql-pkg-yum
Hi,

I have a PostgreSQL 9.4.1 database with Postgis 2.1.5. I noticed there was an update for Postgis to 2.1.7.

I tried to update, but it fails:

$ rpm -qa | grep postgis2
postgis2_94-client-2.1.7-1.rhel6.x86_64
postgis2_94-2.1.7-1.rhel6.x86_64

$ psql
# \dx
                                     List of installed extensions
  Name   | Version |   Schema   |                             Description
---------+---------+------------+---------------------------------------------------------------------
 plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
 postgis | 2.1.5   | public     | PostGIS geometry, geography, and raster spatial types and functions
(2 rows)

# alter extension postgis update;
ERROR:  could not open extension control file "/usr/pgsql-9.4/share/extension/postgis.control": No such file or
directory


There are other relevant files in this directory however (and also two *.control files):

$ ls -1 /usr/pgsql-9.4/share/extension/postgis*
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.0.0--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.0.1--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.0.2--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.0.3--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.0.4--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.0.5--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.0.6--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.0--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.0rc1--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.0rc2--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.0rc3--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.1--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.2--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.3--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.4--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.5--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.6--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.7--2.1.7next.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.7next--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder.control
/usr/pgsql-9.4/share/extension/postgis_tiger_geocoder--unpackaged--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.0.0--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.0.1--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.0.2--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.0.3--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.0.4--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.0.5--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.0.6--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.0--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.0rc1--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.0rc2--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.0rc3--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.1--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.2--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.3--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.4--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.5--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.6--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.7--2.1.7next.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.7next--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology--2.1.7.sql
/usr/pgsql-9.4/share/extension/postgis_topology.control
/usr/pgsql-9.4/share/extension/postgis_topology--unpackaged--2.1.7.sql


How can I update Postgis correctly?

Thanks and keep up all the good work making all these different packages available.

Additional question: can I safely remove all the old *2.0.*–2.1.7* files?


Jeroen




pgsql-pkg-yum by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: ownership of /etc/pgbouncer
Next
From: Devrim Gündüz
Date:
Subject: Re: Postgis 2.1.7 upgrade fails