[postgis-tickets] [PostGIS] #5265: Missing tables when migrating postgres DB

[PostGIS]

#5265: Missing tables when migrating postgres DB
-----------------------+---------------------------
  Reporter:  knightaj  |      Owner:  pramsey
      Type:  defect    |     Status:  closed
  Priority:  medium    |  Milestone:  PostGIS 3.1.8
 Component:  postgis   |    Version:  3.1.x
Resolution:  wontfix   |   Keywords:
-----------------------+---------------------------
Changes (by robe):

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

Comment:

 In PostGIS 3+, postgis_raster was split off as a separate extension.

 What you need to do to be able to restore, is create the extensions
 beforehand.
 This is because only the command `CREATE EXTENSION postgis;` is in your
 restore, so will cause raster functionality to be dropped.

 So to fix, first create the database

 Then in the database do:


 {{{
 CREATE EXTENSION postgis;
 CREATE EXTENSION postgis_raster;
 }}}

 Then restore your backup ontop.

 If you have further questions, please ask on the mailing list
 https://lists.osgeo.org/mailman/listinfo/postgis-users
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5265#comment:3>
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.