[postgis-users] restoring from backup
punk.kish at gmail.com
Thu Aug 9 11:15:45 PDT 2012
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?
More information about the postgis-users