Postgis 2.1.7 upgrade fails
От | Jeroen van Vianen |
---|---|
Тема | Postgis 2.1.7 upgrade fails |
Дата | |
Msg-id | 06D55C75-6003-4CD6-A3AA-E5AC388DDFF6@vanvianen.nl обсуждение исходный текст |
Ответы |
Re: Postgis 2.1.7 upgrade fails
(Devrim Gündüz <devrim@gunduz.org>)
|
Список | 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 по дате отправления: