[postgis-users] restoring from backup

Puneet Kishor 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?

Puneet Kishor

More information about the postgis-users mailing list