Re: How to determine a database is intact?

PFC <lists@boutiquenumerique.com>

From: Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
To: pgsql-general@postgresql.org
Date: 2004-09-05T17:39:27Z
Lists: pgsql-general
>> 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 ?