[PostGIS] #5592: Postgres Upgrade Compatibility with PostGIS Extension

PostGIS trac at osgeo.org
Fri Oct 27 09:53:50 PDT 2023


#5592: Postgres Upgrade Compatibility with PostGIS Extension
-------------------------+-----------------------------------------------
  Reporter:  rama        |      Owner:  pramsey
      Type:  task        |     Status:  closed
  Priority:  medium      |  Milestone:  PostGIS 3.4.1
 Component:  postgis     |    Version:  3.3.x
Resolution:  worksforme  |   Keywords:  PostgreSQL V16 Upgrade Dependency
-------------------------+-----------------------------------------------
Changes (by robe):

 * status:  new => closed
 * resolution:   => worksforme

Comment:

 Since PostGIS 3+, you should be able to easily pg_upgrade from a 3.* to a
 3.*

 That said, to use pg_upgrade to upgrade you to 3.4. Do this

 1) Upgrade your pg 11 from 2.5 to 3.3
 2) Then that said install PG16 PostGIS 3.4.0

 Then you should have no issue doing pg_uprade from 11 3.3 to 16 3.4

 Once you have PG16 upgraded, run


 {{{
 SELECT postgis_extensions_upgrade();
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5592#comment:2>
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