[postgis-users] restoring from backup

Sandro Santilli strk at keybit.net
Mon Aug 13 02:06:15 PDT 2012


On Thu, Aug 09, 2012 at 01:15:45PM -0500, Puneet Kishor wrote:
> 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?

pg_restore should be taking care of this by itself, is it not ?
Or is postgis_restore ruining that part ?

--strk;



More information about the postgis-users mailing list