[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