You are probably installing into a newer version of PostGIS is my guess and PostGIS 3+ now has postgis_raster as a separate extension.
Your restore only has CREATE EXTENSION postgis; so would be missing the postgis_raster bit. If you need raster support, you should do create newdb In you newdb database run CREATE EXTENSION postgis; CREATE EXTENSION postgis_raster; Then follow with your restore From: postgis-users [mailto:[email protected]] On Behalf Of Crawford Jr., Stephen Rand Sent: Thursday, June 18, 2020 11:57 AM To: [email protected] Subject: [postgis-users] dump and restore All, I have a postGIS database that I am moving to a new machine. I tried these forms of dump and restore, which have worked on other databases: pg_dump -Fc db > db.dump createdb newdb pg_restore -v -d newdb db.dump But for this database restore hangs on the first table, which is full of rasters, as are most of the tables in this database. Are there any other flags or techniques that I should be using? Thanks, Steve Stephen Crawford Center For Environmental Informatics The Pennsylvania State University [email protected] <mailto:[email protected]>
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
