Re: Postgis 2.1.7 upgrade fails

Hi,

Sorry, it was a packaging issue :( Thanks for the report.

Fixed. Please upgrade to 2.1.7-2.

Regards, Devrim

On Thu, 2015-04-02 at 22:22 +0200, Jeroen van Vianen wrote:
> 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
>
>
>
>

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR