[postgis-users] dump and restore

[Crawford Jr., Stephen Rand]

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

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