Re: pg_restore and create FK without verification check

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > This doesn't really replace pg_dump/pg_restore, because it probably 
> > wouldn't be able to upgrade a cluster.
> 
> Right, any such physical dump would be limited to restoring a whole
> cluster as-is: no imports into other clusters, no selectivity, no fancy
> games.  The main reason is you'd have to dump and restore pg_clog along
> with the data files.
> 

But that would not help people who would HAVE to use pg_dump/pg_restore (e.g.
to backup/restore a single schema), would it? Depending on the db size, etc.,
creation of FK constraint(s) may take many hours. How should this be handled
then?

Thanks




__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/