Tom Lane wrote: > Rod Taylor <[EMAIL PROTECTED]> writes: > > I vote to disable the checks for pg_restore if the dumpfile has a check > > added to ensure it's the same file that was dumped (an MD5 in the > > header) and it is a full database restore. > > Individual table restores should require the check. > > It is not our business to be making such decisions for the DBA. If > we're going to provide this at all, it should be in the form of a knob > the DBA can tweak if *he* thinks it's safe to omit the check.
We could allow the dba to _enable_ the check if they want it, of course. Basically, default it to checks off rather than on. However, there is no logic that could distinguish a hand-created dump from one we dumped. This is another area where a guc variable identifing a dump would help. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
