Re: How to determine a database is intact?

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to determine a database is intact?
Date: 2004-09-05 17:39:27
Message-ID: opsdu7b1p5cq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 ?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Nolan 2004-09-05 18:23:18 Re: How to determine a database is intact?
Previous Message Pierre-Frédéric Caillaud 2004-09-05 17:34:46 Re: Index on TEXT versus CHAR(32)... fast exact TEXT matching