[PostGIS] #5584: PostGIS Upgrade Issue

[PostGIS]

#5584: PostGIS Upgrade Issue
---------------------------+-------------------------------
  Reporter:  rama          |      Owner:  strk
      Type:  defect        |     Status:  new
  Priority:  critical      |  Milestone:  PostGIS Packaging
 Component:  upgrade/soft  |    Version:  3.3.x
Resolution:                |   Keywords:  windows
---------------------------+-------------------------------
Comment (by rama):

 @robe

 As recommended in ticket 5592. i am trying to upgrade Postgres from V11 to
 V16. similarly, PostGIS 3.3.3 to 3.4.1

 During the Restore process getting below Error
 {{{
 :M:/Database/bakup_01DEC2023.dump:13254: ERROR:  relation
 "o17_transportation.isochrone_edges_walk" does not exist
 psql:M:/Database/bakup_01DEC2023.dump:25576759: ERROR:  no entry in
 "public.pointcloud_formats" for pcid = 1
 CONTEXT:  COPY dfra_tpg_pcld_lidar2015leedsuni_dfra_bsln, line 1, column
 pa:
 "01010000000100000090010000026401000007000000E57006FC5AED68378AC1EDF63499D96677A35A4E62B3ABE5EE55AD9A..."
 psql:M:/Database/bakup_01DEC2023.dump:25715376: ERROR:  no entry in
 "public.pointcloud_formats" for pcid = 1
 CONTEXT:  COPY dfra_tpg_pcld_lidar2018bristolwestbury_dfra_bsln, line 1,
 column pa:
 "0101000000010000009001000002C801000009000000061B6856022448AC16204409D0A190B0193809120186E0905A701126..."
 psql:M:/Database/bakupuk_01DEC2023.dump:25805846: ERROR:  no entry in
 "public.pointcloud_formats" for pcid = 1
 CONTEXT:  COPY dfra_tpg_pcld_lidarpoints50cm_dfra_bsln, line 1, column pa:
 "010100000001000000900100000296010000080000006E5B69616E6671627E638262654F69667C5A74436B467262855A7866..."
 psql:M:/Database/bakup_01DEC2023.dump:26591952: ERROR:  no entry in
 "public.pointcloud_formats" for pcid = 1
 CONTEXT:  COPY dfra_tpg_pcld_lidarpointswarwickuni_dfra_bsln, line 1,
 column pa:
 "01010000000100000090010000036302000078DA1D927B4C8D7118C7579FC765186AFD61F1C7E10F0C9BF15763366BCC94DC..."

 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5584#comment:21>
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.