--- Tom Lane <[EMAIL PROTECTED]> 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/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
