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 ?