[postgis-users] restoring from backup

[Puneet Kishor]

My question is re. cyclic dependencies in the db. If the db has a table t1 which has a custom data type d1, then d1 has to exist before t1 can be restored. Similarly, if a view v1 depends on tables t1 and t2, then both tables have to exist before the view can be restored. This creates problem when dumping a complex db an restoring it on another server.

Is there a way (a switch) that allows restoring a dump, but doesn't do any integrity checking until the entire kaboodle is restored?



--
Puneet Kishor