Postgres Pro
Downloads
Home   >   mailing lists

Re: How to determine a database is intact? - Mailing list pgsql-general

From Pierre-Frédéric Caillaud
Subject Re: How to determine a database is intact?
Date
Msg-id opsdu7b1p5cq72hf@musicbox
Whole thread Raw
In response to Re: How to determine a database is intact?  (Wes <wespvp@syntegra.com>)
Responses Re: How to determine a database is intact?  (Mike Nolan <nolan@gw.tssi.com>)
List pgsql-general
Tree view 
>> 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 ?

pgsql-general by date:

Previous
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Index on TEXT versus CHAR(32)... fast exact TEXT matching
Next
From: Jan Wieck
Date:
Subject: Re: How to determine a database is intact?