From: | "Chen, Dongdong (GE Healthcare)" <DongdongChen(at)ge(dot)com> |
---|---|
To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | <jd(at)commandprompt(dot)com>, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: need help for PostgreSQL consistency check mechanism |
Date: | 2009-04-24 08:22:51 |
Message-ID: | 0332CB5EB6327940B291055AAD964221042E0237@SHAMLVEM02.e2k.ad.ge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
When the OS starts up, it wants to detect whether there is data loss in PostgreSQL from last shutdown, is there a method provided?
Thanks for your help!
B.R.
ChenDongdong
-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Friday, April 24, 2009 10:29 AM
To: Chen, Dongdong (GE Healthcare)
Cc: jd(at)commandprompt(dot)com; Alvaro Herrera; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] need help for PostgreSQL consistency check mechanism
On Thu, Apr 23, 2009 at 8:24 PM, Chen, Dongdong (GE Healthcare) <DongdongChen(at)ge(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | josep porres | 2009-04-24 11:46:59 | update error |
Previous Message | Dhaval Shah | 2009-04-24 07:05:50 | Question regarding pam_pgsql [looking for a BSD License pam_pgsql] |