Re: need help for PostgreSQL consistency check mechanism - Mailing list pgsql-general

From Scott Marlowe
Subject Re: need help for PostgreSQL consistency check mechanism
Date
Msg-id dcc563d10904231928l1e1ef555oba62c63ae9349e11@mail.gmail.com
Whole thread Raw
In response to Re: need help for PostgreSQL consistency check mechanism  ("Chen, Dongdong (GE Healthcare)" <DongdongChen@ge.com>)
Responses Re: need help for PostgreSQL consistency check mechanism
List pgsql-general
On Thu, Apr 23, 2009 at 8:24 PM, Chen, Dongdong (GE Healthcare)
<DongdongChen@ge.com> wrote:
> I wanna know if there is any way or tool to detect the DB data loss or
> damage and inform developer  the result before recovery? If there is
> data loss, the DB could still open or not ?
> Sometimes even if shutdown abnormally, the data still keep in good
> condition.

Assuming non broken hardware and a drive subsystem that doesn't lie
about fsync, and that the dba hasn't turned off fsync, an abnormal
shutdown should NEVER result in a corrupted database.

pgsql-general by date:

Previous
From: "Chen, Dongdong (GE Healthcare)"
Date:
Subject: Re: need help for PostgreSQL consistency check mechanism
Next
From: Dennis Gearon
Date:
Subject: feature suggestion and return to pgsql-general :-)