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

PostGIS trac at osgeo.org
Tue Oct 25 03:17:06 PDT 2022


#5265: Missing tables when migrating postgres DB
----------------------+---------------------------
 Reporter:  knightaj  |      Owner:  pramsey
     Type:  defect    |     Status:  new
 Priority:  medium    |  Milestone:  PostGIS 3.3.2
Component:  postgis   |    Version:  3.3.x
 Keywords:            |
----------------------+---------------------------
 We are currently migrating a postgres database with postgis extension
 enabled.

 Versions as below

 Source Postgres 9.6 Postgis 2.3.3
 Destination Postgres 13 Postgis 3.1.7

 The process uses a dumpall backup and during the restore we get the
 following error

 ERROR:  relation "public.raster_columns" does not exist
 ERROR:  relation "public.raster_overviews" does not exist

 Is there something extra we need to do to restore these ?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5265>
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