> This does make me wonder (again) about some kind of pg_dump regression
> test. ISTM that a test should be doable by building a DB from data files,
> dumping it, restoring it, then using COPY to extract the data back to files
> (and probably doing a sort on the output). We could also store a BLOB or
> two. Then we compare the initial data files with the final ones. This will
> test the integrity of the data & BLOB dump/restore. We then also need to
> test the metadata integrity somehow, probably by dumping & restoring the
> regression DB, but we'd need to modify the pg_dump output somewhat, I think.
Yes, I have often caught dump bugs by doing a COPY/restore/COPY and
comparing the two COPY files. Not sure if that is what you meant.
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
