[postgis-users] dump and restore

Crawford Jr., Stephen Rand src176 at psu.edu
Thu Jun 18 08:56:42 PDT 2020


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?


Stephen Crawford

Center For Environmental Informatics

The Pennsylvania State University

src176 at psu.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200618/2cc4c63f/attachment.html>

More information about the postgis-users mailing list