Re: Is there a tool for checking database integrity - Mailing list pgsql-general

From Tomas Vondra
Subject Re: Is there a tool for checking database integrity
Date
Msg-id 4FA7041C.4050701@fuzzy.cz
Whole thread Raw
In response to Re: Is there a tool for checking database integrity  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
On 7.5.2012 00:56, Bruce Momjian wrote:
> On Mon, May 07, 2012 at 12:37:47AM +0200, Tomas Vondra wrote:
>> Hi,
>>
>> On 6.5.2012 20:47, Clemens Eisserer wrote:
>>> Hi,
>>>
>>> Is there a tool for checking a postgresql database for integrity, so I
>>> would be notified immediatly if something went wrong e.g. with memory
>>> and can go back to the last good backup?
>>> Such a tool would guarantee me I am not sitting on a ticking time bomb
>>> (corrupted database) without even noticing it.
>>
>> No, at least in the current version. The next version (9.2) will support
>> checksums, but it's meant mostly as a protection against failures at the
>> I/O level. It might catch some memory issues, but it certainly won't be
>> 100% protection.
>
> Postgres 9.2 will _not_ support checksums.

Oh, I see - it was bumped to 9.3 and I've missed that.

Sorry for confusion.

Tomas

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Is there a tool for checking database integrity
Next
From: Tulio
Date:
Subject: Re: spanish locale question