Re: How to determine a database is intact?

>> Why isn't doing a restore of those reasonable?
>
> Because of the size and time required.  Right now, it takes at least 24
> hours, with a full hardware configuration (multi-CPU, 8 disk SCSI RAID,
> etc).  That is going to do nothing but increase.  Extrapolating linearly
> the

    I understand you restore to a test server... can you configure your test
server with no fsync, pg will have only one connection so you can bump
sort_mem, and the like ? wil the times will be reasonable then ?

    Doesn't a successful pg_dumpall prove the database is intact ?