[PostGIS] #5899: pg_upgrade fails restore geography because spatial_ref_sys does not exist

[PostGIS]

#5899: pg_upgrade fails restore geography because spatial_ref_sys does not exist
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.2.9
 Component:  postgis  |    Version:  3.4.x
Resolution:           |   Keywords:
----------------------+---------------------------
Comment (by jeevanchalke):

 > I don't quite understand the second comment though, unless the relation
 "public.spatial_ref_sys" does not exist error happens because they tried
 to dump the spatial_ref_sys data before the spatial_ref_sys table was
 created.

 NO. We were trying to dump data as soon as the table was created. However,
 due to the lack of dependency, the geography type is dumped first before
 the public.spatial_ref_sys table structure. And this issue gets resolved
 by adding a dependency entry.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5899#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.