[postgis-tickets] [PostGIS] #4717: upgrading to 3.0.1 from 2.4.4 following docu does not work: "Updating extension postgis from 3.0.1 to 2.4.4" ?!
PostGIS
trac at osgeo.org
Thu Jul 9 04:44:41 PDT 2020
#4717: upgrading to 3.0.1 from 2.4.4 following docu does not work: "Updating
extension postgis from 3.0.1 to 2.4.4" ?!
----------------------+---------------------------
Reporter: tpo | Owner: pramsey
Type: defect | Status: closed
Priority: medium | Milestone: PostGIS 3.0.2
Component: postgis | Version: 3.0.x
Resolution: wontfix | Keywords:
----------------------+---------------------------
Comment (by robe):
From irc
{{{
11:39:22 ReginaObe[m]: ah but you said no such file exists in the
postgresql-10-postgis-3-scripts one -- hmm that sounds like a packaging
mistake
11:39:39 tpo2: I do not know how one can figure that out - with
$(pg_config --sharedir)/extension/ that would be
/usr/share/postgresql/11/extension/postgis.control, however that's for pg
11 and I'm upgrading from pg 10 -> pg 11 so I need the pg 10 control file
and that would be /usr/share/postgresql/10/extension/postgis.control which
comes from the postgresql-10-postgis-2.4-scripts package
11:40:14 Algunenano: Wait, are you updating both things at the
same time?
11:40:26 ReginaObe[m]: at anyrate if you can edit the
postgresql-10-postgis-2.4-script/postgis.control and change the version on
it from 2.4.4 to 3.0.1 that should allow you to upgrade
11:40:53 tpo2: ReginaObe[m], I can remove
/usr/share/postgresql/10/extension/postgis.control and instead symlink
that file to /usr/share/postgresql/10/extension/postgis-3.control
11:41:48 ReginaObe[m]: ah that's where they put it
11:41:48 tpo2: ReginaObe[m], OK, thanks a lot - however that will
only fix it hackishly for me and everybody else will need to hack around
it as well...
11:41:51 ReginaObe[m]: yap do that
11:42:26 ReginaObe[m]: I thought they were supposed to provide a
toggle for that according to Myon - ping Myon
11:42:42 tpo2: Algunenano, I'm first upgrading postgis 2.4.4 ->
3.0.1 in postgres-10 then pg_dumping that and the pg_restore'ing that into
postgres-11
11:43:22 tpo2: ReginaObe[m], thanks a lot (really!) I'll ping
Myon
11:43:25 Algunenano: tpo2: If you are going to dump anyway you
don't need to do the upgrade. Just install postgis (and postgis_raster) in
the new database and load the 2.4 dump
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4717#comment:5>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list